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

select prod_name,count(order_num)
from Products
left join OrderItems using(prod_id)
group by prod_name
order by prod_name;