ORDER BY DESC + LIMIT — recency-anchored peek.
What were the 5 most recent POs we placed? Pull `po_number`, `order_date`, and `qty_ordered` from `fact_purchase_orders`. Sort by order date, most recent first, top 5.
| Column | Type | Key |
|---|---|---|
| po_id | INT | PK |
| po_number | TEXT | |
| sku_id | INT | FK → dim_skus |
| supplier_id | INT | FK → dim_suppliers |
| warehouse_id | INT | FK → dim_warehouses |
| order_date | TEXT | |
| expected_arrival | TEXT | |
| actual_arrival | TEXT | |
| qty_ordered | INT | |
| qty_received | INT | |
| unit_cost | REAL | |
| status | TEXT |
Each hint you reveal reduces the XP you can earn. Try the query first.
One table: `fact_purchase_orders`. Three columns: `po_number`, `order_date`, `qty_ordered`.
ORDER BY `order_date` DESC, then LIMIT 5.
Most recent order date in the seed is around 2026-04-25.