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