Rainbow Deals - hours only!Up to 80% off on all courses and bundles.-Close
Comparisons with NULL
Functions with NULL
COALESCE to the rescue
Revision and practice
27. Exercise 4


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.


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.