select eos.NameOfInstitution as School, eos.EducationOrganizationId as SchoolId, dr.CodeValue as GradeLevel
,s.StudentUniqueId,s.LastSurname,s.FirstName,sra.EducationOrganizationId as ResidentDistrictCode
, eo.NameOfInstitution as ResidentDistrict, dr.Description as Responsibility
from edfi.StudentSchoolAssociation ssa
left join edfi.Student s on s.StudentUSI=ssa.StudentUSI
left join edfi.StudentEducationOrganizationResponsibilityAssociation sra on sra.StudentUSI=ssa.StudentUSI
left join edfi.EducationOrganization eo on eo.EducationOrganizationId=sra.EducationOrganizationId
left join edfi.Descriptor dr on dr.DescriptorId=sra.ResponsibilityDescriptorId
left join edfi.EducationOrganization eos on eos.EducationOrganizationId=ssa.SchoolId
left join edfi.Descriptor dg on dg.DescriptorId=ssa.EntryGradeLevelDescriptorId
order by eos.NameOfInstitution, s.LastSurname, s.FirstName