Revision
Comparisons with NULL
Functions with NULL
COALESCE to the rescue
NULLIF
Revision and practice
27. Exercise 4

Instruction

Goood! Things are getting serious now: let's add another table. You will work with the table product and the table advertisement in the next three exercises.

The table advertisement tells us which products have been advertised so far. It also informs where and when this happened.

Exercise

For each advertisement, show its id, country, start_date and end_date together with the name of the product advertised.

If there is no start_date or no end_date, show 'n/a' instead. If there is no name of the product, show 'no name'. Order the results by the start_date, with the oldest dates coming first.

Stuck? Here's a hint!

It's a quiz. No hints this time.

Console

Code editor

Result

TableConsole