Q&A for committed Christians, experts in Christianity and those interested in learning more
-- 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