0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for students, teachers, and linguists wanting to discuss the finer points of the Chinese language

WITH Combos AS(
    SELECT pt.PostId, STRING_AGG(t.TagName,',') WITHIN GROUP (ORDER BY TagName ASC) AS TagCombo
    FROM PostTags pt
    JOIN Tags t
    ON pt.TagId = t.Id
    GROUP BY pt.PostId
    ),
    ComboCounts AS (
    SELECT TagCombo, COUNT(PostId) Cnt
    FROM Combos
    GROUP BY TagCombo
    )
SELECT TOP 1 TagCombo
FROM ComboCounts
ORDER BY Cnt DESC

view current version

edited dec 3

created dec 3 Janis123