CREATE OR REPLACE FUNCTION sexoVendedorPorModelo(VARCHAR(64))
RETURNS CHARACTER(1) AS
$$
DECLARE
        sex CHARACTER(1);
        quantity INT := 0;
        c record;
BEGIN
        FOR c IN
                SELECT funcionario.sexo AS sexo, COUNT(funcionario.sexo) AS quantity_sold
                FROM venda
                        INNER JOIN carro ON venda.id_carro = carro.id
                        INNER JOIN funcionario ON venda.cpf_vendedor = funcionario.cpf
                WHERE carro.modelo = $1
                GROUP BY funcionario.sexo
        LOOP
        RAISE NOTICE 'Quantidade vendida por homens: %', c.quantity_sold;
                IF c.quantity_sold > quantity THEN
                        quantity := c.quantity_sold;
                        sex := c.sexo;
                END IF;
        END LOOP;

        RETURN sex;
END
$$ LANGUAGE plpgsql;

SELECT sexoVendedorPorModelo('Corsa');