Queries "Case"


#1

Hi everyone, I’m stuck in excersice 14 from Queries.
I actually don’t know what I’m doing wrong.

https://www.codecademy.com/courses/learn-sql-queries/lessons/queries/exercises/case?action=lesson_resume&course_redirect=learn-sql

This is the error that I get:
Type the code in the code editor using the appropriate clauses.

Thanks :slight_smile:

select *,
CASE
when genre = 'romance' then 'fun'
when genre = 'comedy' then 'fun'
else 'serious'
end as 'mood'
from movies;

#2

TRY THIS

SELECT name,
CASE
WHEN genre = ‘romance’ then 'fun’
WHEN genre = ‘comedy’ then ‘fun’

ELSE 'serious’
END as 'mood’
FROM movies;


#3

Lol I’m dumb.
Thanks man!