Q&A for students, teachers, and linguists wanting to discuss the finer points of the Chinese language
WITH PostTagCombinations AS ( SELECT pt.PostId, STRING_AGG(t.TagName, ',') WITHIN GROUP (ORDER BY t.TagName) AS TagCombination FROM PostTags pt, Tags t WHERE pt.TagId = t.Id GROUP BY pt.PostId ), CombinationCounts AS ( SELECT TagCombination, COUNT(*) AS CombinationCount FROM PostTagCombinations GROUP BY TagCombination ) SELECT TOP 5 TagCombination FROM CombinationCounts ORDER BY CombinationCount DESC;