mean answer score as function of response time


Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

with a as (
     pq.CreationDate as question_date,
     pa.CreationDate as answer_date,
     DATEDIFF(hh, pq.CreationDate, pa.CreationDate) daydiff
  from Posts pa
  join Posts pq on pa.ParentId = pq.Id

select daydiff, avg(1.00*Score) quality from a
where daydiff >=0 and daydiff <= 300
group by daydiff
order by daydiff

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results