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

select prod_name,count(oi.order_num)
from Products p left join OrderItems oi on p.prod_id=oi.prod_id
group by p.prod_name
order by p.prod_name