2

0

Please login or register to vote for this query.

(click on this box to dismiss)

Cognitive Sciences Meta

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'
and owneruserid>0
)  
select a.owneruserid,count(a.id) answers from c a,posts b
where a.id=b.acceptedanswerid
and b.acceptedanswerid>0
group by a.owneruserid

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results