Q&A about the site for students, teachers, and linguists wanting to discuss the finer points of the Italian language
SELECT u.Id AS UserId, u.DisplayName, u.Upvotes AS TotalUpvotes, COUNT(p.Id) AS TotalPosts FROM Posts p INNER JOIN Users u ON p.OwnerUserId = u.Id GROUP BY u.Id, u.DisplayName, u.Upvotes ORDER BY u.Id;