select eo.NameOfInstitution,s.LastSurname,s.FirstName,dg.CodeValue as GradeLevel
,dc.CodeValue as CharacteristicCode,dc.ShortDescription as Description,sc.BeginDate,sc.EndDate,sc.DesignatedBy
from edfi.StudentCharacteristic sc
left join edfi.Descriptor dc on dc.DescriptorId=sc.StudentCharacteristicDescriptorId
left join edfi.Student s on s.StudentUSI=sc.StudentUSI
left join edfi.StudentSchoolAssociation ssa on ssa.StudentUSI=s.StudentUSI
left join edfi.EducationOrganization eo on eo.EducationOrganizationId=ssa.SchoolId
left join edfi.Descriptor dg on dg.DescriptorId=ssa.EntryGradeLevelDescriptorId
order by eo.NameOfInstitution,s.LastSurname,s.FirstName