select distinct eo.NameOfInstitution, s.LastSurname as StudentLastName, s.FirstName as StudentFirstName
, dg.CodeValue as GradeLevel
,dr.Description as RacialEthnicCode, do.CodeValue as RaceOrder
from edfi.StudentSchoolAssociation ssa
left join edfi.EducationOrganization eo on eo.EducationOrganizationId=ssa.SchoolId
left join edfi.Student s on s.StudentUSI=ssa.StudentUSI
left join edfi.Descriptor dg on dg.DescriptorId=ssa.EntryGradeLevelDescriptorId
left join edfi.StudentEducationOrganizationAssociationRace sr on sr.StudentUSI=s.StudentUSI
left join mi.StudentEducationOrganizationAssociationMSDSRaceOrder race on race.StudentUSI=ssa.StudentUSI and race.RaceDescriptorId=sr.RaceDescriptorId
left join edfi.Descriptor dr on dr.DescriptorId=sr.RaceDescriptorId
left join edfi.Descriptor do on do.DescriptorId=race.RaceOrderChoiceDescriptorId
order by eo.NameOfInstitution,s.LastSurname,s.FirstName,do.CodeValue,dr.Description