Q&A for those interested in the geology, meteorology, oceanography, and environmental sciences
select top 100 OwnerUserId ,count(id) count_posts from Posts a group by OwnerUserId order by count(id) desc