On January 28th at 9:00 UTC Academy will be unavailable for 10 minutes due to planned maintenance break.
Kickstart 2020 with new opportunities! - hours only!Up to 80% off on all courses and bundles.-Close
GROUP BY – Recap


Okay! All that's left for you to do is to write your own query with COALESCE.


Show the total price paid for all deliveries in each category and a grand total for all categories. Show the Category column and the sum of the TotalPrice. The columns names should be Category and Total. Instead of NULL values in the Category column, show two hyphens (--).

Stuck? Here's a hint!

Use COALESCE(Category,'--') in the SELECT clause.