Question Upvotes Per Hour

0

Please login or register to vote for this query.

(click on this box to dismiss)

Anime and Manga

Q&A for anime and manga fans

WITH S AS (
  SELECT P.OwnerUserId UserId, SUM(P.Score) 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;

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results