All answered number

1

Please login or register to vote for this query.

(click on this box to dismiss)

Computational Science

Q&A for scientists using computers to solve scientific problems

SELECT count(*) 
FROM
  (SELECT id AS questionId,
          acceptedAnswerId,
          creationdate as questionCreation
   FROM posts
   WHERE posttypeid = 1
     AND acceptedanswerid IS NOT NULL) question
JOIN
  (SELECT id AS answerId,
          owneruserid AS answererUID,
          creationDate AS answerCreation
   FROM posts
   WHERE posttypeid = 2) a_answers ON question.acceptedanswerid = a_answers.answerId

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results