select
    prod_name,
    ifnull (orders, 0)
from
    Products a
    left join (
        select
            prod_id,
            count(*) orders
        from
            OrderItems b
        group by
            prod_id
    ) f on f.prod_id = a.prod_id
order by
    prod_name