0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for user experience researchers and experts

select top 100 q.id, q.CreationDate, a.CreationDate, q.Score, a.Score,
  DATEDIFF(year, q.CreationDate, a.CreationDate) as diff
from Posts as q
inner join Posts as a on a.ParentId = q.Id
where q.PostTypeId = 1 
  and a.PostTypeId = 2
  and DATEDIFF(day, q.CreationDate, a.CreationDate) > 0
  and q.AnswerCount = 1
  and q.AcceptedAnswerId is not null
  and q.OwnerUserId = 80274
  order by DATEDIFF(day, q.CreationDate, a.CreationDate) desc

fork query

created oct 20 17 anonymous