Introduction
Providing detailed information and counting objects
Calculating metrics for multiple business objects
Understanding the difference between various count metrics
Instruction
Good job! Are you ready for the last question?
Exercise
Which employees processed the highest -value orders made during June and July 2016?
For each employee, compute the total order value before discount from all orders processed by this employee between 5 July 2016 and 31 July 2016. Ignore employees without any orders processed. Show the following columns: FirstName, LastName, and SumOrders. Sort the results by SumOrders in descending order.
Stuck? Here's a hint!
Join three tables: Orders, OrderItems, and Employees.
