0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

-- By Questions (Including Deleted and Closed)
SELECT TOP 20
  COUNT(*) AS QuestionIncludingDeletedAndClosedCount,
  P.OwnerUserId AS [User Link]
FROM PostsWithDeleted P
--JOIN Users U ON U.Id = P.OwnerUserId
WHERE
  P.PostTypeId = 1 -- Questions
GROUP BY P.OwnerUserId
ORDER BY COUNT(*) DESC
;

fork query

edited jul 7 23

created jul 7 23 starball