Your question is Top Customers by Sales Revenue. Start with the requirements and the one table 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 are given a single sales table from a Deloitte reporting dataset. Write a PostgreSQL query to return the top 10 customers by total revenue. Revenue should be calculated as the sum of sale_amount for each customer, ignoring rows where sale_amount is NULL. Return the customer name and total revenue, sorted from highest to lowest revenue.
| Column | Type | Description |
|---|---|---|
| sale_idPK | INT | Unique identifier for each sale |
| customer_name | VARCHAR(100) | Customer name associated with the sale |
| sale_amount | DECIMAL(10,2) | Revenue amount for the sale |
| sale_date | DATE | Date the sale was recorded |