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

with sss as (Select
Q.CreationDate As QuestionDate, A.CreationDate as AnswerDate,
YEAR(Q.CreationDate) as Y,
DATEDIFF(second, Q.CreationDate, A.CreationDate) as TimeDiff
From Posts A
join Posts Q on A.id = Q.AcceptedAnswerid
where Q.AcceptedAnswerId<> '' AND YEAR(Q.CreationDate)=2017)


select max(TimeDiff) from sss

fork query

edited jan 20

created jan 20 anonymous