0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

SELECT 
  datename(dw, frage.CreationDate), 
  datepart(hh, frage.CreationDate),
  AVG(Datediff(minute, frage.CreationDate, antwort.CreationDate)),
  Count(antwort.Id)
FROM
  (SELECT TOP 7000000 AcceptedAnswerId, CreationDate FROM Posts) frage
  JOIN (SELECT TOP 7000000 Id, CreationDate FROM Posts) antwort
  ON antwort.Id = frage.AcceptedAnswerId
WHERE Datediff(minute, frage.CreationDate, antwort.CreationDate) <= 2*24*60
GROUP BY datename(dw, frage.CreationDate), datepart(hh, frage.CreationDate)

view current version

edited nov 10 13

created nov 10 13 anonymous