Q&A for administrators, end users, developers and designers for Craft CMS
--How many posts have the exact same number of answers?
select count(posts.id), posts.answercount as A from posts
--where posts.answercount A in (
-- select posts.answercount as B from posts
-- where posts.answercount A = posts.answercount B
group by posts.answercount
--order by posts.answercount A desc