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.