Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
GROUP BY – Recap
ROLLUP
Summary

Instruction

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

Exercise

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.