Q&A for SharePoint enthusiasts
select OwnerUserId, count(*) as num_posts from Posts group by OwnerUserId order by num_posts desc;