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

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