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