How to join on null values SQL Server?

MySQL equivalent of PHP in_array(range)

Hatahle

I have a comments table that check if that if for example a student got between 40% and 49% the comment would be "Work Hard" I was able to use PHP in_array range but how can I now use only MYSQL filter the comment according to the mark of the user using only mysql in a PIVOT table