Ranking Vendedores x Orcamentos

SELECT
    VENDEDOR.VEN_CODIGO,
    VENDEDOR.VEN_NOME,
(
    SELECT
        COUNT(*)
    FROM
      ORCAMENTOS ORC2
    INNER JOIN
      VENDEDOR V2 ON(V2.VEN_CODIGO = ORC2.VEN_CODIGO)
    WHERE
      COALESCE( ORC2.ORC_VENDA_EXPORTADA, 0) > 0
      AND ORC2.ECF_DATA >= :ECF_DATA1
      AND ORC2.ECF_DATA <= :ECF_DATA2
      AND ORC2.VEN_CODIGO = VENDEDOR.VEN_CODIGO
) AS ORCAMENTO_EXPORTADO,
(
    SELECT
      SUM(ORC3.ORC_TOTAL_LIQ)
    FROM
      ORCAMENTOS ORC3
    INNER JOIN
      VENDEDOR V2 ON(V2.VEN_CODIGO = ORC3.VEN_CODIGO)
    WHERE
      COALESCE( ORC3.ORC_VENDA_EXPORTADA, 0) > 0
      AND ORC3.ECF_DATA >= :ECF_DATA1
      AND ORC3.ECF_DATA <= :ECF_DATA2
      AND ORC3.VEN_CODIGO = VENDEDOR.VEN_CODIGO
) AS VALOR_ORCAMENTO_EXPORTADO,

    COUNT(*) AS QTDE_TOTAL_ORCAMENTO,
    SUM(ORCAMENTOS.ORC_TOTAL_LIQ) AS VALOR_TOTAL_ORCAMENTO

FROM
    ORCAMENTOS
INNER JOIN
    VENDEDOR ON (VENDEDOR.VEN_CODIGO = ORCAMENTOS.VEN_CODIGO)
WHERE
    ORCAMENTOS.ECF_DATA >= :ECF_DATA1
    AND ORCAMENTOS.ECF_DATA <= :ECF_DATA2
GROUP BY
    VENDEDOR.VEN_CODIGO,
    VENDEDOR.VEN_NOME