Q&A for people interested in conceptual questions about life and challenges in a world where "cognitive" functions can be mimicked in purely digital environment
SELECT p.Id AS [Post Link], p.Title, p.ViewCount FROM Posts p JOIN PostTags pt ON p.Id = pt.PostId JOIN Tags t ON pt.TagId = t.Id WHERE t.TagName = 'java' AND p.PostTypeId = 1 and p.ViewCount > 100000 ORDER BY p.ViewCount DESC;