total_answers_by_year

0

Please login or register to vote for this query.

(click on this box to dismiss)

Sports

Q&A for participants in team and individual sport activities

SELECT
postCreationDate,
floor(avg(ans_time)) avg_ans_time,
floor(min(ans_time)) min_ans_time,
floor(max(ans_time)) max_ans_time
from(
select
CONVERT(DATE, p.creationdate) as postCreationDate,
cast(DATEDIFF(MINUTE, p.creationdate, a.creationdate) as numeric(10,2)) as ans_time
FROM Posts p join posts a
on p.id = a.parentId
)t
group by 
postCreationDate

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results