Revision
Comparisons with NULL
7. NULL with non-equality – practice
Functions with NULL
COALESCE to the rescue
NULLIF
Revision and practice

## Instruction

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

## Exercise

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.

Code editor

TableConsole