SQL: Top 5 Customers by Value | Dataford Interview Questions

Your question is SQL: Top 5 Customers by Value. 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.

Problem

Myntra's Business Analytics team wants to identify its highest-value customers for the previous completed calendar quarter. Write a PostgreSQL query using the customers and orders tables.

Requirements

Define the previous quarter dynamically relative to CURRENT_DATE.
Include only orders whose dates fall within that quarter and whose status is not cancelled.
Aggregate order value by customer, return the top five customers, and sort by total value descending. Use customer_id as a deterministic tie-breaker.

Schema

customers

Column	Type	Description
customer_idPK	INTEGER	Unique Myntra customer identifier
customer_name	VARCHAR(100)	Customer's display name

orders

Column	Type	Description
order_idPK	INTEGER	Unique order identifier
customer_id	INTEGER	Customer who placed the order
order_date	DATE	Date on which the order was placed
order_value	NUMERIC(12,2)	Gross monetary value of the order
status	VARCHAR(20)	Current order status