Save up to $499! Grab all Python courses for $49 or all online courses we’ve ever launched for only $169. Only Feb 11-16. Happy Valentine's!
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.