select prod_name,
    count(order_num) as orders
from Products P left join OrderItems O using(prod_id)
group by
    prod_name
order by
    prod_name ASC;