SELECT all events sorted
Show the promo calendar from `fact_promotions` sorted by start_date. All columns.
| Column | Type | Key |
|---|---|---|
| promo_id | INT | PK |
| sku_id | INT | FK → dim_skus |
| location_id | INT | FK → dim_locations |
| promo_name | TEXT | |
| promo_type | TEXT | |
| start_date | TEXT | |
| end_date | TEXT | |
| lift_pct_actual | REAL |
Each hint you reveal reduces the XP you can earn. Try the query first.
Pull every column for the promo calendar — sort chronologically.
ORDER BY start_date.
All rows.