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