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

Instruction

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

Exercise

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.

Console

Code editor

Result

TableConsole