select sum(a.new) as 'Number of Posts having the exact sa...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Puzzling

Q&A for those who create, solve, and study puzzles

select sum(a.new) as 'Number of Posts having the exact same number of answers' from
(select count(id) as 'new', answercount from posts
group by answercount
having count(id) > 1) as a;



select top 100 * from posts

Enter Parameters

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