Skip to content

1571. Warehouse Manager 👍

1
2
3
4
5
6
7
8
9
SELECT
  Warehouse.name AS warehouse_name,
  SUM(
    Warehouse.units * Products.width * Products.length * Products.height
  ) AS volume
FROM Warehouse
INNER JOIN Products
  USING (product_id)
GROUP BY 1;