Q&A about the site for power users of web applications
SELECT TOP 50000 u.DisplayName, COUNT(p.Id) AS TotalPosts, SUM(p.Score) AS TotalUpvotes FROM Posts p JOIN Users u ON p.OwnerUserId = u.Id GROUP BY u.DisplayName, u.Id ORDER BY u.Id