0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for serious players and enthusiasts of chess

SELECT u.Id, SUM(c.Score) AS NumberOfUpvotes, COUNT (c.Id) AS CommentsCounts
FROM Users u
JOIN Comments c
ON c.Userid = u.Id
GROUP BY u.Id
ORDER BY u.Id

fork query

edited nov 8

created nov 8 anonymous