mean answer score as function of response time

0

Please login or register to vote for this query.

(click on this box to dismiss)

Ukrainian Language Meta

Q&A about the site for linguists, teachers and students of the Ukrainian language

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

select daydiff, sum(1.00*Score) from a
group by daydiff
order by daydiff

Enter Parameters

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