Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Creating Basic SQL Reports in SQL Server

Introduction
Providing detailed information and counting objects
Calculating metrics for multiple business objects
Understanding the difference between various count metrics
Summary
17. Question 3

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.