select distinct eo.NameOfInstitution, s.LastSurname as StudentLastName, s.FirstName as StudentFirstName , ssa.SchoolYear , ssa.EntryDate , dg.CodeValue as GradeLevel, dg.ShortDescription as GradeLevelDesc, st.ShortDescription as Gender , ssa.ExitWithdrawDate, de.CodeValue as ExitWithdrawCode, de.ShortDescription as ExitWithdrawDesc, ssa.PrimarySchool , dr.CodeValue as ResidencyCode, dr.ShortDescription as ResidencyDesc, ssa.ClassOfSchoolYear , dp.CodeValue as GradPlanCode, dp.ShortDescription as GradPlanDesc,ssa.GraduationSchoolYear,ssa.RepeatGradeIndicator ,(select top 1 sem.ElectronicMailAddress from edfi.StudentElectronicMail sem where sem.StudentUSI=s.StudentUSI) as Email 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 de on de.DescriptorId=ssa.ExitWithdrawTypeDescriptorId left join edfi.Descriptor dr on dr.DescriptorId=ssa.ResidencyStatusDescriptorId left join edfi.Descriptor dp on dp.DescriptorId=ssa.GraduationPlanTypeDescriptorId left join edfi.SexType st on st.SexTypeId=s.SexTypeId order by eo.NameOfInstitution,s.LastSurname,s.FirstName