select
    t1.prod_name,
    count(t2.prod_id) orders
from 
    Products t1
left join
    OrderItems t2
on
    t1.prod_id = t2.prod_id
group by
    t1.prod_name
order by    
    t1.prod_name