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,sum(t.isindate) answers from 
--(
select top 100  a.ownerUserid ,
case when a.CreationDate between '2012/7/1' and '2013/7/1' then a.id else null 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