Accepted answer count by score

1

Please login or register to vote for this query.

(click on this box to dismiss)

Doesn't count self-accepted answers.

MathOverflow

Q&A for professional mathematicians

select a.score, count(*) count
from posts a
join posts q on a.id = q.AcceptedAnswerId
    and q.OwnerUserId != ##UserId##
where a.OwnerUserId = ##UserId##
and a.PostTypeId = 2
group by a.score
order by 1

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results