Save up to $499! Grab all Python courses for $49 or all online courses we’ve ever launched for only $169. Only Feb 11-16. Happy Valentine's!
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!