0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for those interested in the study of the fundamental nature of knowledge, reality, and existence

SELECT
COUNT(Posts.Id) AS NumQuestions,
OwnerUserId,
DisplayName,
SUM(Score) AS TotalQuestionVotes,
SUM(Score)*5 AS LikelyRepGain
FROM
Posts
JOIN
Users
ON
Posts.OwnerUserId=Users.Id
WHERE
PostTypeId=1
GROUP BY
OwnerUserId,DisplayName
ORDER BY
TotalQuestionVotes DESC

fork query

created nov 14 19 anonymous