Your question is SQL Top Five Customers. 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.
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.
customer_name is NULL.SUM.| 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 |