select distinct d.CodeValue,d.ShortDescription as [LanguageDescriptor],lt.Description as [LanguageUse],count(*) as [Count]
from edfi.StudentEducationOrganizationAssociationLanguage sl
left join edfi.StudentEducationOrganizationAssociationLanguageUse slu on slu.StudentUSI=sl.StudentUSI and slu.LanguageDescriptorId=sl.LanguageDescriptorId
left join edfi.Descriptor d on d.DescriptorId=sl.LanguageDescriptorId
left join edfi.Descriptor lt on lt.DescriptorId=slu.LanguageUseDescriptorId
group by d.CodeValue,d.ShortDescription,lt.Description