Your question is Top-Performing Segments Query. Start with the requirements and the three tables on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
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 |