0

Please login or register to vote for this query.

(click on this box to dismiss)

Enter Query Description

Q&A for anime and manga fans

-- Answer rate
-- 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

fork query

edited jan 28 12 jon.doe7137

created jun 22 10 davy.landman