How to write valid SQL query with CASE construct?

Question

SQL

Query construction - SELECT ts CASE description WHEN 'bad' THEN 'rain,storm' ELSE 'good' END weather_conditions FROM weather_records;
The terminal swears at such a request.

in the task, you need to isolate the data for each hour and divide the data into bad and good.

Answer 1

SELECT ts CASE description WHEN 'bad' THEN 'rain,storm' ELSE 'good' END weather_conditions FROM weather_records;
correct like this:
SELECT CASE WHEN description 'bad' THEN 'rain,storm' ELSE 'good' END AS weather_conditions FROM weather_records;