Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
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:

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, delivery_date, and the sum of total_price (rename the column total).

### Stuck? Here's a hint!

Use:

GROUP BY ROLLUP(category, delivery_date)