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

-- Enter Query Title
-- Enter Query Description
select a.owneruserid,b.displayname,a.answers from (
select top 100  t.owneruserid ,count(t.ID) answers from 
select  a.ownerUserid ,a.ID from Posts a, posts b  
where a.id=b.acceptedanswerid
and b.acceptedanswerid>0
--and a.CreationDate between '2012/7/1' and '2013/7/1' 
--and a.CommunityOwnedDate is null and a.ClosedDate is null
)  t
group by t.owneruserid
order by count(t.ID) desc
) a ,users b
where a.owneruserid=b.id

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results