Your question is Analyze Customer Purchase Trends with Window Functions. 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.
An online retail company wants to analyze customer spending trends over months. Write a SQL query to calculate the total spending for each customer by month, along with the cumulative spending for each customer over time.
customers and orders tables on customer_id.| Column | Type | Description |
|---|---|---|
| customer_idPK | INT | Unique identifier for each customer |
| customer_name | VARCHAR(255) | Name of the customer |
| Column | Type | Description |
|---|---|---|
| order_idPK | INT | Unique identifier for each order |
| customer_id | INT | Identifier linking to the customer who made the order |
| order_date | DATE | Date when the order was placed |
| amount | DECIMAL(10,2) | Total amount of the order |