Answer count by days since question asked


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 = 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

Switch sites:
loading Hold tight while we fetch your results