select eo.EducationOrganizationId,eo.NameOfInstitution,d.CodeValue,eic.IdentificationCode
from edfi.LocalEducationAgency lea
left join edfi.EducationOrganization eo on eo.EducationOrganizationId=lea.LocalEducationAgencyId
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