Best April deals - hours only!Up to 80% off on all courses and bundles.-Close
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!