Stack-Overflow-tags-counts

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT 
  * 
FROM 
  (
  SELECT

    tags_delimited,
    count(*) as cnt

  FROM
    (SELECT
        STRING_AGG(t.TagName, ',') WITHIN GROUP (ORDER BY t.TagName) AS tags_delimited
    FROM Posts p
    INNER JOIN PostTags pt ON p.Id = pt.PostId
    INNER JOIN Tags t ON pt.TagId = t.Id
    WHERE t.count > 5000
    GROUP BY p.Id
    ) ts
    


  GROUP BY 
  ts.tags_delimited

  ) gb 
WHERE cnt > 35

ORDER BY tags_delimited

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results