SELECT TOP 20 COUNT(*) AS NonDeletedNonClosedQuestionCount,

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

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
;

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results