Q&A for scientific skepticism
SELECT Users.Id, Users.DisplayName, COUNT(Comments.Id) AS total_comments, SUM (Comments.Score) AS total_upvotes FROM Comments JOIN Users ON Comments.UserId = Users.Id GROUP BY Users.Id, Users.DisplayName ORDER BY Users.Id;