Q&A about the site for active researchers, academics and students of physics
SELECT Users.Id, Users.DisplayName, COUNT (Posts.Id) AS total_posts, Users.Upvotes AS total_upvotes FROM Posts JOIN Users ON Posts.OwnerUserId = Users.Id GROUP BY Users.Id, Users.DisplayName,Users.Upvotes ORDER BY Users.Id;