select ssa.EntryGradeLevelDescriptorId,d.CodeValue as Code,count(*) as [Count],d.Namespace from edfi.StudentSchoolAssociation ssa left join edfi.GradeLevelDescriptor gld on gld.GradeLevelDescriptorId=ssa.EntryGradeLevelDescriptorId left join edfi.Descriptor d on d.DescriptorId=ssa.EntryGradeLevelDescriptorId group by ssa.EntryGradeLevelDescriptorId,d.CodeValue,d.Namespace order by ssa.EntryGradeLevelDescriptorId