=arrayformula(substitute(importXML("https://at.fuelo.net/fuel/type/gasoline?lang=en"; "//table[@class=('table')]//tr");" €/l";""))=arrayformula(REGEXREPLACE(TEXT(importXML("https://at.fuelo.net/fuel/type/gasoline?lang=en"; "//table[@class=('table')]//tr");"0.00");"€.*";""))
=ArrayFormula(filter(0+AE7:AF106;0+AE7:AE106>=$B$6;0+AE7:AE106<=$B$6+10))
=join(", ";QUERY(A1:F11; "select A where B='д' "))
Не удалось завершить регистрацию. Распространенные ошибки при регистрации: (а) Использование предоплаченных карт. Oracle принимает только кредитные и дебетовые карты. (б) Преднамеренное или непреднамеренное маскирование местоположения или идентификационных данных. (в) Ввод неполных или неточных данных счета. Если вы допустили одну их вышеперечисленных ошибок, повторите попытку. В противном случае обратитесь в службу поддержки клиентов Oracle.
SELECT
AVG(value) AS avg_value,
CASE WHEN LOWER(TO_CHAR(created_date, 'Day')) = 'monday' THEN 'Понедельник'
WHEN LOWER(TO_CHAR(created_date, 'Day')) = 'tuesday' THEN 'Вторник'
WHEN LOWER(TO_CHAR(created_date, 'Day')) = 'wednesday' THEN 'Среда'
WHEN LOWER(TO_CHAR(created_date, 'Day')) = 'thursday' THEN 'Четверг'
WHEN LOWER(TO_CHAR(created_date, 'Day')) = 'friday' THEN 'Пятница'
WHEN LOWER(TO_CHAR(created_date, 'Day')) = 'saturday' THEN 'Суббота'
WHEN LOWER(TO_CHAR(created_date, 'Day')) = 'sunday' THEN 'Воскресенье'
END week
FROM results
GROUP BY created_date;where (item, location, action_date) IN
SELECT FieldA,
GROUP_CONCAT(FieldB ORDER BY FieldB SEPARATOR ',') AS FieldBs
FROM TableName
GROUP BY FieldA
ORDER BY FieldA;SELECT FieldA,
STRING_AGG(FieldB, ',') WITHIN GROUP (ORDER BY FieldB) AS FieldBs
FROM TableName
GROUP BY FieldA
ORDER BY FieldA;SELECT FieldA,
LISTAGG(FieldB, ',') WITHIN GROUP (ORDER BY FieldB) AS FieldBs
FROM TableName
GROUP BY FieldA
ORDER BY FieldA;[
{
"id": "01coin",
"name": "01coin",
"symbol": "zoc"
},
{
"id": "bitcoin",
"name": "Bitcoin",
"symbol": "btc"
}
]https://api.coingecko.com/api/v3/simple/price?ids=bitcoin&vs_currencies=rub%2Cusd=ImportJSON("https://api.coingecko.com/api/v3/simple/price?ids=bitcoin&vs_currencies=rub%2Cusd"; "/bitcoin/usd";)
select case when a.position = 0
then 0
else a.position +1
end position
from (SELECT COUNT(*) AS `position`
FROM `season_" + season + "`
WHERE `RATING` > ( SELECT `RATING`
FROM `season_" + season + "`
WHERE `ID`= '" + id + "' LIMIT 1 )
) as a