Q&A about the site for serious players and enthusiasts of chess
SELECT u.Id, Count(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