select eo.EducationOrganizationId,eo.NameOfInstitution,d.CodeValue,eic.IdentificationCode
from edfi.School sch
left join edfi.EducationOrganization eo on eo.EducationOrganizationId=sch.SchoolId
left join edfi.EducationOrganizationIdentificationCode eic on eic.EducationOrganizationId=eo.EducationOrganizationId
left join edfi.Descriptor d on d.DescriptorId=eic.EducationOrganizationIdentificationSystemDescriptorId
order by eo.EducationOrganizationId,d.CodeValue