SELECT prod_name, (
    SELECT sum(quantity)
    FROM OrderItems as O
    where P.prod_id = O.prod_id
) quant_sold
FROM  Products as P