Average answer time (in days) for quality questions in 2013

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for programmers

select
year(p.creationdate),
avg(cast(datediff(minute, p.creationdate, p2.creationdate) as bigint))/1440.
from Posts p, Posts p2 
where p.posttypeid=1 
  and p.score>5
  and p.creationdate>'2010-01-01'
  and p.creationdate<'2014-01-01'
  and p.acceptedanswerid is not null
  and p.acceptedanswerid=p2.id
  and p2.creationdate<DATEADD(month, 6, p.creationdate)
  group by year(p.creationdate)

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results
:records returned in :time ms:cached