Q&A about the site for SharePoint enthusiasts
SELECT OwnerUserId AS UserId, COUNT(Id) AS NumberOfPosts FROM Posts GROUP BY OwnerUserId ORDER BY NumberOfPosts DESC;