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