Q&A about the site for practitioners, researchers, and students in cognitive science, psychology, neuroscience, and psychiatry
with c as (
select owneruserid,id,parentid,communityowneddate from posts
where communityowneddate between '2012/7/1' and '2013/7/1'
select top 100 a.owneruserid,count(a.id) answers from c a,posts b
group by a.owneruserid
order by count(a.id) desc