Q&A for practitioners, researchers, and students in cognitive science, psychology, neuroscience, and psychiatry
SELECT u.Id AS UserId, u.DisplayName, u.Upvotes AS TotalUpvotes, COUNT(p.Id) AS TotalPosts FROM Posts p JOIN Users u ON p.OwnerUserId = u.Id GROUP BY u.Id, u.DisplayName, u.Upvotes ORDER BY u.Id;