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
Get to know the database
Basic revenue metrics
Summary

Instruction

Good job! Let's do one more exercise with INTERVAL.

Exercise

The quarter is a period of three months – the first quarter (Q1) is a period of the first three months (January, February, March), the second quarter (Q2) is a period of the second three months (April, May, June), etc. In the world of finance, the quarter is a very important time period and quarterly analyses are very common.

Show the total revenue generated in the first quarter of 2018. Group revenue by each shipping country. Show two columns: ship_country and total_revenue. You can use the following code:

CAST('2018-01-01' AS DATE) + INTERVAL '3' month

Stuck? Here's a hint!