牛客SQL学习 _必知必会_45_104 返回产品名称和每一项产品的总订单数

---

一、题目

二、代码

select table1.prod_name,count(table1.order_num)
from
(
    select pro.prod_name,pro.prod_id,ord.order_num
    from Products pro
    left join OrderItems ord
    on pro.prod_id = ord.prod_id

) table1
group by table1.prod_name
order by table1.prod_name

三、运行结果