select distinct d.CodeValue,d.ShortDescription as [LanguageDescriptor]
,lnt.Description as [LanguageType],lt.Description as [LanguageUse]
,count(*) as [Count]
from edfi.StudentLanguage sl
left join edfi.StudentLanguageUse slu on slu.StudentUSI=sl.StudentUSI and slu.LanguageDescriptorId=sl.LanguageDescriptorId
left join edfi.Descriptor d on d.DescriptorId=sl.LanguageDescriptorId
left join edfi.LanguageUseType lt on lt.LanguageUseTypeId=slu.LanguageUseTypeId
left join edfi.LanguageDescriptor ld on ld.LanguageDescriptorId=d.DescriptorId
left join edfi.LanguageType lnt on lnt.LanguageTypeId=ld.LanguageTypeId
group by d.CodeValue,d.ShortDescription,lnt.Description,lt.Description