Q&A about the site for researchers and developers who explore the principles of a system through analysis of its structure, function, and operation
-- Tags ordered by total number of questions SELECT DENSE_RANK() OVER (ORDER BY COUNT(*) DESC) AS SN, COUNT(*) AS Num, Tags.TagName FROM Posts INNER JOIN PostTags ON PostTags.PostId = Posts.Id INNER JOIN Tags ON Tags.Id = PostTags.TagId WHERE Posts.PostTypeId = 1 GROUP BY Tags.TagName HAVING COUNT(*) > 100 ORDER BY Num DESC