Computed metric in ORDER BY, LIMIT N.
For the spend review I need our top 5 SKUs by total purchase value across all received POs. Purchase value = `qty_received * unit_cost` per PO line, summed per SKU. Return sku_name and total_value (rounded to 2 decimals). Top 5 only, highest first.
| 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 |
| Column | Type | Key |
|---|---|---|
| sku_id | INT | PK |
| sku_code | TEXT | |
| sku_name | TEXT | |
| category | TEXT | |
| unit_cost | REAL | |
| reorder_point | INT |
Each hint you reveal reduces the XP you can earn. Try the query first.
JOIN `fact_purchase_orders` to `dim_skus` ON `sku_id`. Filter `status = 'received'`.
Per-row value = `qty_received * unit_cost`. SUM that per SKU.
GROUP BY sku_name, ORDER BY total_value DESC, LIMIT 5. ROUND(SUM(...), 2).