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
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.