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(Users.Upvotes) AS total_upvotes FROM Comments JOIN Users ON Comments.Id = Users.Id GROUP BY Users.Id, Users.DisplayName ORDER BY Users.Id;