Warehouse stock summary

Question

Supply chain planners need a one-line health check per warehouse before the festive restock.

From `warehouse_stock`, return one row per `warehouse_code` with:

- `sku_count` — number of SKUs stocked
- `total_units` — total units on hand
- `avg_unit_price` — average unit price rounded to 2 decimals

Accepted Answer

Step 1: Collapse the rows to one per warehouse with `GROUP BY warehouse_code`. Step 2: `COUNT(sku)` gives the number of stocked SKUs in that warehouse. Step 3: `SUM(units)` totals the physical inventory, while `MIN(units)` and `MAX(units)` expose the thinnest and deepest lines. Step 4: `AVG(unit_price)` returns many decimal places on a `NUMERIC` column, so wrap it in `ROUND(..., 2)` to match the requested precision. Step 5: Alias every aggregate so the output columns are self-describing.

Warehouse stock summary

More Aggregate Functions questions

Asked at Walmart