Q&A for people studying math at any level and professionals in related fields
SELECT Users.Id, Users.DisplayName, COUNT (Posts.Id) AS total_posts, SUM(Users.Upvotes) AS total_upvotes FROM Posts JOIN Users ON Posts.OwnerUserId = Users.Id GROUP BY Users.Id, Users.DisplayName ORDER BY Users.Id;