Best April deals - 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'