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
