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

select top 100  t.owneruserid,count(t.id) answers from 
(
select top 100   a.ownerUserid ,
case when a.CreationDate between '2012/7/1' and '2013/7/1' then 1 else 0 end id 
from Posts a, posts b  
where a.id=b.acceptedanswerid
and b.acceptedanswerid>0
)  t
group by t.owneruserid
order by count(t.id) desc

Enter Parameters

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