Q&A about the site for active researchers, academics and students of physics
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;