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

Revenue Trend Analysis in SQL Server

Introduction
Get to know the database
Basic revenue metrics
Summary

Instruction

Great! One more exercise!

Exercise

For each employee, find their quarter-to-date revenue. Show three columns: EmployeeId, LastName, and TotalRevenue.

Stuck? Here's a hint!

Join the Orders and Employees tables. Use the following condition in the WHERE clause:

OrderDate >= DATEADD(Quarter, DATEDIFF(Quarter, 0, GETDATE()), 0)