select concat(c.endYear-1,'-',right(c.endYear,2)) as academicYear, count(distinct cs.personID) as uniqueStudents
from icde.customstudent cs
join icde.campusattribute ca
  on ca.[object] LIKE 'DOE Alt%'
  and ca.[element] = 'doeProgramCode'
  and cs.attributeid = ca.attributeid
  and cs.said = ca.said
join icde.enrollment e
  on cs.personID = e.personID
  and cs.said = e.said
join icde.calendar c
  on e.calendarid = c.calendarid
  and e.said = c.said
  and cs.date between c.startdate and c.enddate
where 1=1
  and cs.said = '664-ICDE'
  and cs.value = '03A'
group by c.endYear