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