0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people interested in the history and origins of science and mathematics

-- Unanswered Questions by Tag
-- Shows the number of unanswered questions by tag for the most popular tags.

DECLARE @minQuestionCount int = 500
DECLARE @topN int = 50

-- Order by rankings
SELECT
  COUNT(c.Id) AS CommentCount
FROM Posts q
  INNER JOIN Comments c ON q.Id = c.PostId
  INNER JOIN Users u ON c.UserId = u.Id
WHERE
    (q.PostTypeId = 1) AND
    (q.ClosedDate IS NULL) AND
    (u.DisplayName LIKE '%[^a-zA-Z0-9]aws%' OR u.AboutMe LIKE '%[^a-zA-Z0-9]aws%')

view current version

edited dec 4 20

created dec 4 20 anonymous