Айсерч логотип

SELECT date(ts) AS date, hour(ts) AS hour, CASE WHEN

SELECT date(ts) AS date, hour(ts) AS hour, CASE WHEN description LIKE '%rain%' OR description LIKE '%storm%' THEN 'Bad' ELSE 'Good' END AS weather_conditions FROM weather_records WHERE ts BETWEEN '2017-11-05 00:00:00' AND '2017-11-06 00:00:00'
Дополнительные параметры: codeFlowType: codeMistake codeFlowLang: SQL
Создано: 31.05.2023 12:14

SELECT date(ts) AS date, hour(ts) AS hour, CASE WHEN description LIKE '%rain%' OR description LIKE '%storm%' THEN 'Bad' ELSE 'Good' END AS weather_conditions FROM weather_records WHERE ts BETWEEN '2017-11-05 00:00:00' AND '2017-11-06 00:00:00'

SELECT 
  DATE(ts) AS date, 
  HOUR(ts) AS hour, 
  CASE 
    WHEN description LIKE '%rain%' OR description LIKE '%storm%' THEN 'Bad' 
    ELSE 'Good' 
  END AS weather_conditions 
FROM 
  weather_records 
WHERE 
  ts BETWEEN '2017-11-05 00:00:00' AND '2017-11-06 00:00:00'

Ошибка не обнаружена.