select eem.EEMEducationalEntityMasterId,eem.EEMEntityOfficialName,d.Description,c.PersonalTitlePrefix,c.FirstName,c.MiddleName,c.LastSurname,IsLeadAdministrator
,c.MailingAddressStreetNumberName,c.MailingAddressApartmentRoomSuiteNumber,c.MailingAddressCity,'MI' as MailingAddressState, c.MailingAddressPostalCode
,c.ElectronicMailAddress,c.TelephoneNumber,c.TelephoneNumberExt
from mi.EEMEntityContact c
left join edfi.Descriptor d on d.DescriptorId=c.EEMContactTypeDescriptorId
left join mi.EEMEducationalEntityMaster eem on eem.EEMEducationalEntityMasterId=c.EEMEducationalEntityMasterId
order by eem.EEMEntityOfficialName,d.Description,c.LastSurname,c.FirstName