从Products表中检索所有的产品名称以及对应的销售总数
从 Products 表中检索所有的产品名称以及对应的销售总数
https://www.nowcoder.com/practice/2b289b78de1546f38fd24e17e56f1bec
方法一:
SELECT
p.prod_name,
st.quant_sold
FROM
Products AS p
LEFT JOIN (
SELECT
prod_id,
SUM(quantity) AS quant_sold
FROM
OrderItems
GROUP BY
prod_Id
) AS st
ON st.prod_id = p.prod_id
方法二:
SELECT
p.prod_name,
st.quant_sold
FROM
Products AS p,
(
SELECT
prod_id,
SUM(quantity) AS quant_sold
FROM
OrderItems
GROUP BY
prod_Id
) AS st
WHERE
st.prod_id = p.prod_id
爱玛科技成长空间 4人发布
投递拼多多集团-PDD等公司10个岗位