SELECT
    vclic_codigo,
    vclis_nombre,
    (
        SELECT SUM
            ( fctav_saldo )
        FROM
            GA_Alumina.comercial.fcta_ctaxcobrar
        WHERE
            [fctac_vendedor] = 66
            AND [fctac_cliente] = t2.vclic_codigo
            AND [fctac_tipo] IN ( 'CC', 'ND' )
            AND [fctab_estado] = 'P'
            AND [fctav_saldo] > 0
            AND ( fctaf_vence ) BETWEEN '2018-08-19'
            AND '2018-08-25'
    ) AS a_vencer,
    (
        SELECT SUM
            ( fctav_saldo )
        FROM
            GA_Alumina.comercial.fcta_ctaxcobrar
        WHERE
            [fctac_vendedor] = 66
            AND [fctac_cliente] = t2.vclic_codigo
            AND [fctac_tipo] IN ( 'CC', 'ND' )
            AND [fctab_estado] = 'P'
            AND [fctav_saldo] > 0
            AND ( fctaf_vence ) < '2018-08-19'
    ) AS vencido,
(
        SELECT SUM
            ( fctav_saldo )
        FROM
            GA_Alumina.comercial.fcta_ctaxcobrar
        WHERE
            [fctac_vendedor] = 66
            AND [fctac_cliente] = t2.vclic_codigo
            AND [fctac_tipo] IN ( 'CC', 'ND' )
            AND [fctab_estado] = 'P'
            AND [fctav_saldo] > 0
            AND ( fctaf_vence ) > '2018-08-25'
    ) AS corriente
FROM
    GA_Alumina.comercial.vcli_cliente AS t2
WHERE
    vclic_vendedor = 66
    AND vclis_estado = 'A'
GROUP BY
    vclic_codigo,
    vclis_nombre