0
(click on this box to dismiss)
select *
from Users u join
(select top 10 a.OwnerUserId as Id, count(a.OwnerUserId) as TrueAnswer
from (select * from Posts where PostTypeId=2) a join
(select * from Posts where PostTypeId=1) q
on a.Id=q.AcceptedAnswerId
group by a.OwnerUserId
order by TrueAnswer desc) s
on u.Id=s.Id
order by s.TrueAnswer desc;