[SQL] Case 문

Case statement 

fun if genre is romance

fun if genre is  comedy

serious in all other cases 

SELECT name,

CASE

      WHEN genre = 'romance' THEN 'fun'

            WHEN genre = 'comedy' THEN 'fun'

            ELSE 'serious'

       END 

FROM movies;