Answer rate on tags

0

Please login or register to vote for this query.

(click on this box to dismiss)

Enter Query Description

Stack Overflow

Q&A for professional and enthusiast programmers

-- Answer rate on tags
-- Enter Query Description


SELECT
  (
     SELECT
       count(*)
     FROM
       Posts as P1
     INNER JOIN Posts as P2 ON P1.AcceptedAnswerId = P2.Id
  ) as AnsweredQuestions,
  (
     SELECT
       count(*)
     FROM
       Posts as P1
     INNER JOIN Posts as P2 ON P1.AcceptedAnswerId = P2.Id
     WHERE P2.Score > 2
  ) as QualityAnsweredQuestions,
  (
     SELECT
       count(*)
     FROM
       Posts as P1
     WHERE
       P1.PostTypeId = 1
  ) as TotalQuestions

Enter Parameters

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