1

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

-- 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
)  t
group by t.owneruserid
order by count(t.ID) desc
) a ,users b
where a.owneruserid=b.id

Enter Parameters

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