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