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, Reputation, S.TotalAnswerScore / DATEDIFF(Day, U.CreationDate, GETDATE()) FROM S INNER JOIN Users U ON S.UserId = U.Id ORDER BY S.TotalAnswerScore / DATEDIFF(Hour, U.CreationDate, GETDATE()) DESC;