select prod_name,count(order_num) orders
from Products a 
left join
OrderItems b
on a.prod_id=b.prod_id
group by prod_name
order by prod_name