select eo.NameOfInstitution as Schools,StudentUniqueId as UIC,s.LastSurname,s.FirstName,d.ShortDescription as Grade,ssch.ExitWithdrawDate
from edfi.Student s
left join edfi.StudentSchoolAssociation ssch on ssch.StudentUSI=s.StudentUSI
left join edfi.EducationOrganization eo on eo.EducationOrganizationId=ssch.SchoolId
left join edfi.Descriptor d on d.DescriptorId=ssch.EntryGradeLevelDescriptorId
left join edfi.StudentParentAssociation spa on spa.StudentUSI=s.StudentUSI
where spa.StudentUSI is null and ssch.StudentUSI is not null
order by eo.NameOfInstitution,s.LastSurname,s.FirstName