Answer count by days since question asked

0

Please login or register to vote for this query.

(click on this box to dismiss)

Amateur Radio

Q&A for amateur radio enthusiasts

with sub as
(
select id,
    datediff(minute, creationdate, (select creationdate from posts a where a.id = q.acceptedAnswerid)) as mins
from posts q
where posttypeid = 1
)
select mins, count(id)
from sub
group by mins
having mins >= 0
order by mins

Enter Parameters

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