SQL Top Five Customers | Dataford Interview Questions

Farallon Capital Management's investor activity report needs a concise view of its highest-volume customers. Write a PostgreSQL query that identifies the top five customers by total sales amount.

Requirements

Exclude rows where customer_name is NULL.
Aggregate sales by customer using SUM.
Return the five customers with the largest totals, ordered from highest to lowest sales volume.

Schema

customer_sales

Column	Type	Description
sale_idPK	INTEGER	Unique identifier for the sale
customer_name	VARCHAR(100)	Name of the customer associated with the sale
sale_amount	NUMERIC(12,2)	Monetary value of the sale
sale_date	DATE	Date on which the sale occurred

Your question is SQL Top Five Customers. Start with the requirements and the one table in the Question tab.

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

Problem

Farallon Capital Management's investor activity report needs a concise view of its highest-volume customers. Write a PostgreSQL query that identifies the top five customers by total sales amount.

Requirements

Exclude rows where customer_name is NULL.
Aggregate sales by customer using SUM.
Return the five customers with the largest totals, ordered from highest to lowest sales volume.

Schema

customer_sales

Column	Type	Description
sale_idPK	INTEGER	Unique identifier for the sale
customer_name	VARCHAR(100)	Name of the customer associated with the sale
sale_amount	NUMERIC(12,2)	Monetary value of the sale
sale_date	DATE	Date on which the sale occurred

Your question is SQL Top Five Customers. Start with the requirements and the one table in the Question tab.

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