user1733108 user1733108 - 6 months ago 87
SQL Question

stackover flow query

when using the stack overflow data explorer, how can I select questions with 3 or more answers?

Answer

There's an AnswerCount field on the Posts table:

SELECT * FROM Posts WHERE AnswerCount >= 3 AND PostTypeId = 1