0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for anime and manga fans

WITH S AS (
  SELECT P.OwnerUserId UserId, SUM(P.Score) * 1.0 TotalAnswerScore
  FROM Posts P INNER JOIN
       PostTypes PT ON P.PostTypeId = PT.Id
  WHERE PT.Name = 'Answer'
  GROUP BY P.OwnerUserId
)
SELECT TOP 10
  U.DisplayName,
  S.TotalAnswerScore / DATEDIFF(Hour, U.CreationDate, GETDATE())
FROM S INNER JOIN
     Users U ON S.UserId = U.Id
ORDER BY S.TotalAnswerScore / DATEDIFF(Hour, U.CreationDate, GETDATE()) DESC;

fork query

edited jan 26 12

created jan 26 12 anonymous