Most popular StackOverflow tags

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

-- Most popular StackOverflow tags
SELECT i.TagName AS Tag, row_number() OVER (ORDER BY i.Num DESC) AS Rank,
       i.Num AS TotalQuestions
FROM (
    SELECT Count(PostId) AS Num, TagName
    FROM Tags, PostTags, Posts
    WHERE Tags.Id = PostTags.TagId
      AND Posts.Id = PostId
    GROUP BY TagName
    HAVING Count(PostId) > 800
) AS i
ORDER BY Rank ASC;

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results