Comparisons with NULL
Functions with NULL
COALESCE to the rescue
Revision and practice
29. Exercise 6


That's it! Okay, one more exercise and we'll let you off.


For each advertisement, show its id and the following sentence: The advertisement with id ID for the product NAME was started on DATE.

Replace ID, NAME and DATE with the proper columns. If there is no NAME, show the product id, if the product id is missing too, show 'no name'. If there is no DATE, show 'n/a'. Ignore products with missing price.

Stuck? Here's a hint!

It's a quiz. No hints this time.