select P.prod_name,sum(OI.quantity) quant_sold
from Products P join OrderItems OI on P.prod_id = OI.prod_id
group by P.prod_name