SELECT prod_name, count(order_num) as orders
FROM Products P
LEFT JOIN OrderItems O on P.prod_id = O.prod_id
GROUP BY prod_name
ORDER BY prod_name