Q&A about the site for members of the workforce navigating the professional setting
-- Get top 5000 Python questions with their key metrics SELECT TOP 5000 q.Id AS [Post Link], q.Title, q.Score, q.ViewCount, q.AnswerCount, q.CreationDate, q.LastActivityDate, q.FavoriteCount, q.AcceptedAnswerId, q.Body FROM Posts q INNER JOIN PostTags pt ON q.Id = pt.PostId INNER JOIN Tags t ON pt.TagId = t.Id WHERE q.PostTypeId = 1 -- 1 for questions AND t.TagName = 'sql' AND q.ClosedDate IS NULL -- Only open questions AND q.Score > 0 -- Questions with positive score ORDER BY q.Score DESC, -- Get highest scored questions q.ViewCount DESC -- For equal scores, prefer more viewed questions