SELECT COUNT(ULTIMO_TA)
FROM VW_estagiarios VW

WHERE
    TIPO_FIM = 'VIGENTE'
    AND
    FIM >= GETDATE()
    AND
    FIM <= '20190630'
    AND
    VW.ULTIMO_TA NOT IN (
                select RA.ID_IN_TA
                from TAB_RA_ACOMPANHAMENTO RA
                where
                    RA.ID_IN_CONTRATO = VW.CONTRATO
                    and
                    CANCELAMENTO_SD_RA_A is NULL
                    and
                    DEVOLUCAO_SD_RA_A is NULL)