Only this week, get the SQL Complete Track of 9 courses in a special prize of $330 $89!
Comparisons with NULL
7. NULL with non-equality – practice
Functions with NULL
COALESCE to the rescue
Revision and practice


Fantastic! Let's do one more exercise in this regard.


Select the name for all products together with their categories and types. Exclude rows with category 'kitchen' and those rows which have no category set.

Stuck? Here's a hint!

Use the non-equality sign != in the WHERE clause. Remember to put the category name in apostrophes.