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%')