select prod_name,
count(oi.prod_id) as orders
from Products as p
left join OrderItems as oi
on p.prod_id = oi.prod_id
group by prod_name
order by prod_name