Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Standard SQL Functions

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

Instruction

Fantastic! Let's do one more exercise for this topic.

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.