instruction: Top 100 most viewed on a tag.
response: SELECT p.ViewCount, p.Id AS "post_link" FROM dbo.Posts AS p INNER JOIN dbo.PostTags AS pt ON p.Id = pt.PostId INNER JOIN dbo.Tags AS t ON pt.TagId = t.Id WHERE p.PostTypeId = 1 AND t.TagName = '##TagName:string?hugo##' ORDER BY p.ViewCount DESC LIMIT 100