Q&A about the site for power users of web applications
SELECT TOP 50000 Users.Id AS UserId, COUNT(Comments.Id) AS TotalComments, SUM(Comments.Score) AS TotalUpVotes FROM Comments JOIN Users ON Comments.UserId = Users.Id GROUP BY Users.Id ORDER BY Users.Id