select P.prod_name,O.quant_sold from Products P,(select prod_id,sum(quantity) quant_sold from OrderItems group by prod_id) O where P.prod_id = O.prod_id;