select eem.EEMEducationalEntityMasterId,eem.EEMEntityOfficialName,eic.EEMEntityIdentificationCode,d.CodeValue
from mi.EEMEducationalEntityMasterEEMIdentificationCode eic
left join edfi.Descriptor d on d.DescriptorId=eic.EEMIdentificationSystemDescriptorId
left join mi.EEMEducationalEntityMaster eem on eem.EEMEducationalEntityMasterId=eic.EEMEducationalEntityMasterId
where d.CodeValue='NCES'
order by eem.EEMEducationalEntityMasterId,d.CodeValue