Q&A for experienced flyers, pilots, and builders of drones and model aircraft
SELECT u.Id AS UserId, u.DisplayName, COUNT(c.Id) AS TotalComments, SUM(c.Score) AS TotalCommentUpvotes FROM Comments c JOIN Users u ON c.UserId = u.Id GROUP BY u.Id, u.DisplayName ORDER BY u.Id;