Q&A for professional and enthusiast programmers
SET STATISTICS IO ON; SELECT TOP 100 q.Id, q.Title, COUNT(c.Id) AS CommentCount FROM Posts q INNER JOIN Comments c ON q.Id = c.PostId WHERE q.AcceptedAnswerId IS NULL AND q.PostTypeId = 1 GROUP BY q.Id, q.Title HAVING COUNT(c.Id) > 10 ORDER BY CommentCount DESC