SELECT prod_name, (SELECT SUM(quantity) FROM OrderItems i WHERE i.prod_id = o.prod_id) AS quant_sold FROM Products o;