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 AmountOfAnsweredQuestions,
  (
     SELECT
       count(*)
     FROM
       Posts as P1
     INNER JOIN Posts as P2 ON P1.AcceptedAnswerId = P2.Id
     WHERE P2.Score > 2
  ) as AmountOfQualityAnsweredQuestions,
  (
     SELECT
       count(*)
     FROM
       Posts as P1
  ) as TotalQuestions
Order BY AmountOfAnsweredQuestions DESC, TotalQuestions DESC

Enter Parameters

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