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
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: first_name, last_name, and sum_orders. Sort the results by sum_orders in descending order.
Stuck? Here's a hint!
Join three tables: orders, order_items, and employees.
