select distinct eo.NameOfInstitution, s.LastSurname as StudentLastName, s.FirstName as StudentFirstName
, dg.CodeValue as GradeLevel, pd.Ethnicity, seoa.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 msds.PersonalDemographics pd on pd.StudentUSI=ssa.StudentUSI
left join edfi.StudentEducationOrganizationAssociationRace sr on sr.StudentUSI=ssa.StudentUSI
left join edfi.Descriptor rt on rt.DescriptorId=sr.RaceDescriptorId
left join mi.StudentEducationOrganizationAssociationMSDSRaceOrder sro on sro.StudentUSI=ssa.StudentUSI
left join edfi.StudentEducationOrganizationAssociation seoa on seoa.StudentUSI=ssa.StudentUSI
left join edfi.Descriptor rt1 on rt1.DescriptorId=sro.RaceDescriptorId
left join edfi.Descriptor dr on dr.DescriptorId=sro.RaceOrderChoiceDescriptorId
order by eo.NameOfInstitution,s.LastSurname,s.FirstName