select *
from
( select person_uid,-- substr(program, 1,2) as type, substr(program,4,8) as Subject,
program_desc--,  program
    ,academic_year_graduation
    from academic_outcome 
    where (academic_year_graduation >='1718' and academic_year_graduation <='2122')
    and  status in ('CC','AW')
)
pivot (count(person_uid) for academic_year_graduation in (1718,1819,1920,2021,2122)) order by program_desc
;