Questions and Answers from the top 10 posters by number of posts

0

Please login or register to vote for this query.

(click on this box to dismiss)

Quantum Computing Meta

Q&A about the site for engineers, scientists, programmers, and computing professionals interested in quantum computing

SELECT
    YEAR(Posts.CreationDate),
    Users.Id as [User Link],
    PostTypeId,
    COUNT(*) AS [Posts]
FROM
    Posts
  INNER JOIN
    Users ON Users.Id = OwnerUserId
WHERE
    (PostTypeId = 1 OR PostTypeId = 2) AND CommunityOwnedDate is null
GROUP BY Posts.PostTypeId, Users.Id, YEAR(Posts.CreationDate)
ORDER BY YEAR(Posts.CreationDate) ASC, [Posts] DESC

-- Based on "Top 500 answerers on the site"
-- from https://data.stackexchange.com/stackoverflow/query/952/top-500-answerers-on-the-site
-- ok i never did figure out how to get the Top 10 per year sorry, I'll just do that by hand

Enter Parameters

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