Welcome to the SQL screen.
The question is on your right: Calculate Monthly Sales Growth by Product Category. 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?
A retail company needs to analyze its sales performance. Write a SQL query to calculate the month-over-month sales growth for each product category.
sales and products tables by product_id.| Column | Type | Description |
|---|---|---|
| idPK | INT | Primary key |
| product_id | INT | Foreign key referencing products |
| sale_date | DATE | Date of the sale |
| amount | DECIMAL | Sale amount |
| Column | Type | Description |
|---|---|---|
| idPK | INT | Primary key |
| category | VARCHAR(255) | Product category |