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