How to combine a CASE with IS NOT NULL? New York Restaurants

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’

ELSE ‘Poor’

END AS ‘Ranking’

FROM nomnom;

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.