SELECT C.nome, C.cnpj, C.cep FROM(
          SELECT deref(CT.cliente) FROM carregar_table CT
            WHERE CT.auxiliar.supervisor.cpf = '211.111.111-15'
              GROUP BY CT.auxiliar ORDER BY COUNT(CT.contrato) DESC
      )C WHERE ROWNUM = 1;