Q&A about the site for those who base their lives on Jewish law and tradition and anyone interested in learning more
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;