It's Autumn! Prices fall like leaves! - hours only!Up to 80% off on all courses and bundles.-Close
Review
Comparisons with NULL
Functions with NULL
COALESCE to the rescue
NULLIF
Review and practice
25. Exercise 2

Instruction

That's very good! Let's see how you cope with Exercise 2.

Exercise

Show the name of all products together with their price. If the price is equal to 19.99 change it to NULL. However, make sure there aren't any NULLs in the price column, show 'unknown' instead of them. Make sure the latter column is named price.

Stuck? Here's a hint!

It's a quiz. No hints this time.