Comparisons with NULL
Functions with NULL
COALESCE to the rescue
Instruction
That's it! Okay, one more exercise and we'll let you go.
Exercise
For each advertisement, show its id and the following sentence (as 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 started_date, show 'n/a'. Ignore products with missing price.
Stuck? Here's a hint!
It's a quiz. No hints this time.
