注意要使用groupby
这样的题好多呀，累了，毁灭吧。

select prod_name,sum(quantity) as quant_sold
from Products t inner join OrderItems t1 on t.prod_id = t1.prod_id
group by prod_name

其他方法 略