Definition of "top" is "most numerous posts", which aligns with the definition used by the generalist badge.
Q&A about the site for software quality control experts, automation engineers, and software testers
ROW_NUMBER() OVER (ORDER BY postCount DESC),
SELECT TOP 100
COUNT(*) AS postCount
GROUP BY tagid
ORDER BY COUNT(*) DESC
JOIN tags ON tags.id = tagid