Q&A for people looking to bypass life's everyday problems with simple tricks
SELECT ParentId, COUNT(*) AS answers From Posts WHERE PostTypeId = 2 GROUP BY ParentId HAVING COUNT(*)>8 ORDER BY answers DESC