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

select p.prod_name,ifnull(count(o.order_num),0) orders from Products p left join OrderItems o on p.prod_id=o.prod_id group by p.prod_name order by p.prod_name;