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

Introduction
Total revenue for multiple periods
Calculating deltas
Creating "revenue in quarters" reports
Summary
21. Question 4

Instruction

Well done! Now, the final question.

Exercise

For all orders shipped to Germany, create a "revenue in quarters" report showing the total quarterly revenue in each year. The report should look like this:

year Q1 Q2 Q3 Q4
2016 0 0 18975.67 16431.48
2017 11929.90 42017.24 23575.24 39797.81
2018 54893.32 22664.02 0 0
... ... ... ... ...

Order the results by year.

Stuck? Here's a hint!