SELECT id
FROM ProdutosPreferidos
WHERE id IN (SELECT id
             FROM Clientes
             WHERE id = 'Roberto Sales do Areal')
    AND
        id NOT IN (SELECT id
                   FROM VendaProdutos
                   WHERE id IN (SELECT id
                                FROM Clientes
                                WHERE id = 'Roberto Sales do Areal'))