Q&A about the site for serious players and enthusiasts of chess
SELECT u.Id, SUM(u.UpVotes) AS UpVotesCounts, COUNT (p.Id) AS PostCounts FROM Users u JOIN Posts p ON p.OwnerUserId = u.Id GROUP BY u.Id ORDER BY u.Id