Introduction
The ISNULL() function
The COALESCE() function
The NULLIF() function
Summary
18. Exercise 2

Instruction

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

Exercise

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!