select eo.NameOfInstitution,s.LastSurname,s.FirstName,s.StudentUniqueId,d.ShortDescription,ssa.EntryDate,ssa.ExitWithdrawDate,sca.CohortIdentifier,sca.BeginDate,sca.EndDate 
from edfi.StudentCohortAssociation sca
left join edfi.Student s on s.StudentUSI=sca.StudentUSI
left join edfi.StudentSchoolAssociation ssa on ssa.StudentUSI=sca.StudentUSI
left join edfi.Descriptor d on d.DescriptorId=ssa.EntryGradeLevelDescriptorId
left join edfi.EducationOrganization eo on eo.EducationOrganizationId=ssa.SchoolId
where (sca.CohortIdentifier like '%remote%' or 
sca.CohortIdentifier like '%hybrid%' or
sca.CohortIdentifier like '%person%') and (ssa.SchoolYear is null or ssa.SchoolYear=(select syt.SchoolYear from edfi.SchoolYearType syt where syt.CurrentSchoolYear=1))
order by eo.NameOfInstitution,s.LastSurname,s.FirstName