In the lesson: https://www.codecademy.com/courses/learn-sql/projects/learn_sql_query_table
We create this code:
SELECT name,
CASE
WHEN review > 4.5 THEN 'Extraordinary'
WHEN review > 4 THEN 'Excellent'
WHEN review > 3 THEN 'Good'
WHEN review > 2 THEN 'Fair'
ELSE 'Poor'
END AS 'Review'
FROM nomnom;
Does the order of the WHEN statements matter? How does the compiler read the information? For example if the code was ordered where 4.5 was after 4 would that change the results? Thanks.