select a1.prod_name,count(a2.order_num) from Products as a1 
left join OrderItems as a2 on a1.prod_id = a2.prod_id
group by a1.prod_name
order by a1.prod_name