Volkswagen Group Italia needs a quarterly view of its strongest product segments across the latest three quarters of available sales data. Write a PostgreSQL query that ranks segments by net revenue and returns the top two segments for each quarter.
sale_date values and include that quarter plus the two preceding quarters.| Column | Type | Description |
|---|---|---|
| segment_idPK | INT | Unique product segment identifier |
| segment_name | VARCHAR(80) | Commercial product segment name |
| Column | Type | Description |
|---|---|---|
| product_idPK | INT | Unique product identifier |
| product_name | VARCHAR(120) | Vehicle or product name |
| segment_id | INT | Referenced product segment |
| Column | Type | Description |
|---|---|---|
| sale_idPK | INT | Unique sale identifier |
| product_id | INT | Referenced product |
| sale_date | DATE | Date on which the sale was recorded |
| units | INT | Number of units sold |
| net_revenue | NUMERIC(12,2) | Net sales revenue in euros |