Q&A for professional and enthusiast programmers
-- Enter Query Title -- Enter Query Description SELECT TOP 100 TagName AS Tag, PT.C AS Count FROM Tags T INNER JOIN (SELECT TagId, C = Count(*) FROM PostTags GROUP BY TagId) PT ON T.Id = PT.TagId WHERE PT.C > 500 ORDER BY PT.C ASC