Find the most viewed posts on Stackoverflow

To see the most viewed posts on Stackoverflow, you can query posts based on view count (query tool link).

For example, to see the most popular posts on ‘Scala’, do this:

SELECT *
FROM Posts p
JOIN PostTags pt ON p.Id = pt.PostId
JOIN Tags t ON pt.TagId = t.Id 
WHERE TagName = 'scala'
ORDER BY ViewCount DESC