Welcome to the SQL screen.
The question is on your right: Analyze Customer Purchase Trends with Window Functions. Read through the requirements and the two tables first.
Run and submit your code as often as you need. You also have five interviewer messages this session - want to talk through your approach, or are you ready to start coding?
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 |