How would you use pivoting to reshape data for reporting?
Use the provided product and sales tables to produce a reporting-ready result for the first quarter of 2025.
category, product_name, january_sales, february_sales, march_sales, and q1_sales.category, then product_name ascending.| Column | Type | Description |
|---|---|---|
| product_idPK | INT | Unique product identifier |
| product_name | VARCHAR(100) | Product name |
| category | VARCHAR(60) | Product category |
| Column | Type | Description |
|---|---|---|
| sale_idPK | INT | Unique sale identifier |
| product_id | INT | Product associated with the sale |
| sale_date | DATE | Date of the sale |
| net_sales | NUMERIC(12,2) | Net sales amount, which may be null when not recorded |