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