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.category, month, total_sales, previous_month_sales, and growth_percentage.month as YYYY-MM.category ascending, then month ascending.previous_month_sales and growth_percentage to NULL for each category's first month.growth_percentage to two decimal places.| 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 |