select prod_name, (
    select sum(quantity)
    from OrderItems
    where prod_id=p.prod_id
) quant_sold
from Products p;