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