Answers by user on the last year

0

Please login or register to vote for this query.

(click on this box to dismiss)

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.

Statistical Analysis

Q&A for people interested in statistics, machine learning, data analysis, data mining, and data visualization

select OwnerUserId [User Link], 
  Reputation,
  count(*) as [Answers]
from Posts 
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

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results