题解 | #返回产品名称和每一项产品的总订单数#

select
    prod_name,
    count(order_num) as orders
from
    Products left outer join OrderItems
    on Products.prod_id = OrderItems.prod_id
group by
    prod_name
order by
    prod_name