Answers by year author joined the site, by month

1

Please login or register to vote for this query.

(click on this box to dismiss)

Physics

Q&A for active researchers, academics and students of physics

select dateadd(month, datediff(month, 0, a.CreationDate), 0),
  cast(year(u.CreationDate) as varchar(8)) AccountCreationYear, 
  count(*) Answers
from Posts a
join Users u on u.Id=a.OwnerUserId and u.CreationDate < a.CreationDate
where PostTypeId=2
group by dateadd(month, datediff(month, 0, a.CreationDate), 0), year(u.CreationDate)
order by dateadd(month, datediff(month, 0, a.CreationDate), 0)

Enter Parameters

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