Hi. here is the question.
While I was doing New York Restaurants case in SQL, I have came up with a question.
WHEN review > 4.5 THEN ‘Extraordinaty’
WHEN review > 4 THEN ‘Excellent’
WHEN review > 3 THEN ‘Good’
WHEN review > 2 THEN ‘Fair’
END AS ‘Ranking’
So there was 2 restaurants where review IS NULL. I don’t want to see them on my list, in any sense. Is that possible?
Thanks for helping.