Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
The ISNULL() function
The COALESCE() function
The NULLIF() function
18. Exercise 2


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


For each product, show its:

  • ID,
  • type (name the column ProductType),
  • LaunchDate (name the column NewLaunchDate).

If the LaunchDate is NULL, show the current date instead. If there is no product type, show N'no type'. Order the results by NewLaunchDate, with the oldest dates appearing first.

Stuck? Here's a hint!

It's a quiz. No hints this time!