Products表中检索所有的产品名称以及对应的销售总数

select
    Products.prod_name as prod_name,
    sum(OrderItems.quantity) as quant_sold
from
    Products,OrderItems
where Products.prod_id=OrderItems.prod_id
group by
    prod_name;