0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for participants in team and individual sport activities

--select count(*) from (
SELECT question.creationdate Years,
--datepart(year,question.creationdate) Years, 
DATEDIFF(day, question.creationdate, asnswer.creationdate) ResponseInDays
--count(*) HowManyQuestion 
FROM posts question 
inner join posts asnswer 
on question.AcceptedAnswerId = asnswer.id
where question.creationdate BETWEEN '2009-04-01' AND '2009-06-30'--= 2009
and DATEDIFF(day, question.creationdate, asnswer.creationdate) >= 0
--group by datepart(year,question.creationdate)
--DATEDIFF(day, question.creationdate, asnswer.creationdate)
--order by datepart(year,question.creationdate)
--DATEDIFF(day, question.creationdate, asnswer.creationdate)
--desc
--)a

fork query

edited mar 18 19

created jan 8 19 anonymous