Your question is Top 10 Customers by Volume. 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.
Chase analytics needs a customer-level view of transaction volume for reporting in the Chase mobile app. Write a PostgreSQL query that identifies the 10 customers with the highest total value of completed transactions.
customers to transactions using customer_id.status is COMPLETED.SUM(transaction_amount) for each customer.| Column | Type | Description |
|---|---|---|
| customer_idPK | INT | Unique Chase customer identifier |
| customer_name | VARCHAR(100) | Customer display name |
| customer_segment | VARCHAR(30) | Optional customer segment |
| Column | Type | Description |
|---|---|---|
| transaction_idPK | INT | Unique transaction identifier |
| customer_id | INT | Customer associated with the transaction |
| transaction_amount | NUMERIC(12,2) | Monetary value of the transaction |
| transaction_date | DATE | Date the transaction occurred |
| status | VARCHAR(20) | Transaction processing status |