On January 21th at 14:15 UTC , progression through exercises will be unavailable for 10 minutes due to a planned maintenance break.
Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
Reports with revenue in categories


Perfect! Let's try an additional exercise.


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

Stuck? Here's a hint!

Use the following argument in the WHERE clause:

OrderDate >= '20170101' AND OrderDate < '20170701'