SELECT A.OwnerUserId, B.DisplayName, A.TotalScore FROM ( ...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Health Meta

Q&A for medical specialists, students, dietitians, and anyone with health-related questions

SELECT
  A.OwnerUserId,
  B.DisplayName,
  A.TotalScore
FROM (
  SELECT
    TOP(25)
    OwnerUserId,
    SUM(Score) AS TotalScore
  FROM
    Posts
  WHERE
    Body LIKE '%Mathematica%'
  GROUP BY
    OwnerUserId
  ORDER BY TotalScore DESC
) A INNER JOIN Users B ON A.OwnerUserId = B.Id

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results