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;