WHERE with date filter and LIMIT
Pull the 20 most recent actuals from `fact_actuals`. Show sku_id, period_date, units_sold.
| Column | Type | Key |
|---|---|---|
| actual_id | INT | PK |
| sku_id | INT | FK → dim_skus |
| location_id | INT | FK → dim_locations |
| period_date | TEXT | |
| units_sold | INT | |
| revenue | REAL |
Each hint you reveal reduces the XP you can earn. Try the query first.
Sort by date with the freshest first, then cap the result.
LIMIT 20.
Three columns.