select distinct eo.NameOfInstitution, s.LastSurname as StudentLastName, s.FirstName as StudentFirstName
, dg.CodeValue as GradeLevel, pd.RacialEthnicCode, s.HispanicLatinoEthnicity, rt.ShortDescription as Race, rt1.ShortDescription as MSDSRace, dr.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.Descriptor ds on ds.DescriptorId=s.SchoolFoodServicesEligibilityDescriptorId
left join msds.PersonalDemographics pd on pd.StudentUSI=ssa.StudentUSI
left join edfi.StudentRace sr on sr.StudentUSI=ssa.StudentUSI
left join edfi.RaceType rt on rt.RaceTypeId=sr.RaceTypeId
left join extension.StudentMSDSRaceOrder sro on sro.StudentUSI=ssa.StudentUSI
left join edfi.RaceType rt1 on rt1.RaceTypeId=sro.RaceTypeId
left join edfi.Descriptor dr on dr.DescriptorId=sro.RaceOrderChoiceDescriptorId
order by eo.NameOfInstitution,s.LastSurname,s.FirstName