Stack Overflow query to select questions with 3 or more answers

Question

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

In your question "the corresponding answers"...do you mean "Accepted Answer Id" in the Table or all answers in each question? Would you explain more? — Cloud Cho, Sep 20 '22 at 21:22

score 2 · Answer 1 · answered Nov 28 '16 at 04:52

2

There's an AnswerCount field on the Posts table:

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

answered Nov 28 '16 at 04:52

Joel Coehoorn

Thanks . How do i select the corresponding answers as well.? – user1733108 Nov 28 '16 at 04:57
With a JOIN. But you need to the filter the results more. This will pull quite a large amount of data back, and the data explorer limits you to 50,000 rows. – Joel Coehoorn Nov 28 '16 at 04:58
Sounds like you need a basic SQL tutorial. That's out of scope here. – Joel Coehoorn Nov 28 '16 at 05:46

score 0 · Answer 2 · answered Nov 28 '16 at 04:52

0

you can see the number of answers on the left side of the question. the number in green box is the number of correct answers.

answered Nov 28 '16 at 04:52

safwan

2 Answers2