SQL104 返回产品名称和每一项产品的总订单数（left join..on.. ,group by）

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

left join一个数据条多的表
count（order_num）,group by 另一个字段