Q&A about the site for students, teachers, and linguists wanting to discuss the finer points of the Italian language
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;