Q&A for professional and enthusiast programmers
-- By Non-Deleted, Non-Closed Questions SELECT TOP 20 COUNT(*) AS NonDeletedNonClosedQuestionCount, P.OwnerUserId AS [User Link] FROM Posts P --JOIN Users U ON U.Id = P.OwnerUserId WHERE P.PostTypeId = 1 -- Questions AND P.ClosedDate IS NULL GROUP BY P.OwnerUserId ORDER BY COUNT(*) DESC ;