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

注意 外连接right join 可能存在产品没有订单，也要显示和统计，