Distribution of max answer score

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

with questions as
(
  select max(a.Score) score
  from Posts q
       join Posts a on a.ParentId = q.Id
  group by q.Id
)

select score, count(*)
from questions
group by score
order by score

Enter Parameters

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