SELECT
DISTINCT
id_matricula,
bl_ativo,
nu_presenca,
ava_rec.id_tipodeavaliacao,

CASE
    WHEN ava_rec.id_tipodeavaliacao > 0 THEN 'Recuperação'
    ELSE 'Prova Final'
END AS 'st_avaliacao'

FROM vw_avaliacaoagendamento AS avag
OUTER APPLY (
    SELECT
    CASE
        WHEN nu_presenca IS NULL THEN id_tipodeavaliacao
        ELSE id_tipodeavaliacao + 1
    END AS id_tipodeavaliacao
) AS ava_rec

WHERE
avag.id_avaliacaoagendamento IN (SELECT TOP 1 id_avaliacaoagendamento FROM vw_avaliacaoagendamento AS ava WHERE ava.id_matricula = avag.id_matricula ORDER BY id_tipodeavaliacao DESC, id_chamada DESC )

AND avag.id_matricula = 57867