题目链接:点击打开链接
题目大意:略。
解题思路:略。
AC 代码
SELECT name WAREHOUSE_NAME, SUM(units * Width * Length * Height) VOLUME FROM Warehouse w JOIN Products p USING(product_id) GROUP BY name
题目链接:点击打开链接
题目大意:略。
解题思路:略。
AC 代码
SELECT name WAREHOUSE_NAME, SUM(units * Width * Length * Height) VOLUME FROM Warehouse w JOIN Products p USING(product_id) GROUP BY name