How many answers did users answer on the last year?
You can select the minimum number of answers to be considered.
It also returns the reputation of such users.
It is ordered by the number of answers in descending order.
Q&A for people interested in statistics, machine learning, data analysis, data mining, and data visualization
select OwnerUserId [User Link],
count(*) as [Answers]
join Users u on u.Id = OwnerUserId
where PostTypeId = 2
and Posts.CreationDate >= DATEADD(month,-12, DATEADD(month, DATEDIFF(month,0,GETDATE()), 0) )
group by OwnerUserId, Reputation
having count(*) > ##MinAnswers##
order by [Answers] desc