Date-Driven Revenue Query

MediumSQL · PostgreSQL00:00

Practice interviewer

In session

5 left

00:00

Your question is Date-Driven Revenue Query. Start with the requirements and the two tables on the right.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

You need to log in / sign up to run or submit.

Problem

Microsoft Store analysts need to identify the highest-value customers from the most recently completed calendar quarter. Assume the query runs on August 29, 2026, so the target period is April 1 through June 30, 2026.

Write a PostgreSQL query to join customers with their orders and return the top three customers by total order revenue.

Requirements

Filter orders to the last completed calendar quarter using PostgreSQL date functions.
Calculate total revenue for each customer with SUM.
Return the customer name, customer segment, and total revenue.
Sort by total revenue descending, then customer ID ascending to make ties deterministic.

Schema

customers

Column	Type	Description
customer_idPK	INT	Unique customer identifier
customer_name	VARCHAR(100)	Customer's name
segment	VARCHAR(30)	Customer segment

orders

Column	Type	Description
order_idPK	INT	Unique order identifier
customer_id	INT	Customer associated with the order
order_date	DATE	Date the order was placed
amount	NUMERIC(12,2)	Revenue amount for the order

Tablescustomersorders

Your solutionPostgreSQL

You need to log in / sign up to run or submit.

Run a query to see results