Kickstart 2020 with new opportunities! - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
Reports with revenue in 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: CategoryName and TotalRevenue.

Stuck? Here's a hint!

Use the following argument in the WHERE clause:

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