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;