SQL Top Five Customers

EasySQL · PostgreSQL

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

Tablescustomer_sales

CodePostgreSQL

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

Run your query to see results here.