Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Standard SQL Functions

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

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.