Q&A for computer enthusiasts and power users
SELECT t.TagName, preg.Title, preg.ViewCount FROM Tags t, PostTags pt, Posts preg WHERE t.Id = pt.TagId AND pt.PostId = preg.Id AND preg.ParentId IS NULL AND preg.ViewCount > 2000000 AND ViewCount >= ALL(SELECT ViewCount FROM PostTags pt2, Posts p WHERE pt2.TagId = t.Id AND pt2.PostId = p.Id);