Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
Reports with revenue in categories
Revenue in time periods for selected categories
Summary

## Instruction

Perfect! Let's try an additional exercise.

## Exercise

For all orders placed in the first six months of 2017, calculate the total revenue for all categories. Show two columns: category_name and total_revenue.

### Stuck? Here's a hint!

Use the following argument in the WHERE clause:

order_date >= '2017-01-01' AND order_date < '2017-07-01'