Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles
SELECT TagId, ROW_NUMBER() OVER (ORDER BY PostCount DESC) FROM (SELECT TagId, COUNT(*) AS PostCount FROM PostTags GROUP BY TagId) AS TagRankings;