Introduction
GROUP BY – Recap
ROLLUP
Summary

Instruction

Great! We see that ROLLUP added two new rows to the query result: overall averages for each contestant and a general overall average for all contestants:

LEAD

Now it's your turn to try ROLLUP with the Delivery table.

Exercise

Show how much was spent for each Category on each day, for each Category in general, and for all days and all categories. Show the following columns: Category, DeliveryDate, and the sum of TotalPrice (rename the column Total).

Stuck? Here's a hint!

Use:

GROUP BY ROLLUP(Category, DeliveryDate)