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