Revision
Comparisons with NULL
Functions with NULL
COALESCE to the rescue
NULLIF
Revision and practice
28. Exercise 5

Instruction

Nice! Go, go, go!

Exercise

For each product with a non-NULL name, show its id and the number of advertisements associated with it. Sort the results by the id in the descending order.

Stuck? Here's a hint!

It's a quiz. No hints this time.

Console

Code editor

Result

TableConsole