Question to Answer Ratio

0

Please login or register to vote for this query.

(click on this box to dismiss)

Mythology Meta

Q&A about the site for enthusiasts and scholars of mythology and folklore

WITH qAndA AS (SELECT Posts.OwnerUserId,
          SUM(CASE
                  WHEN Posts.PostTypeId = 1 THEN 1
                  ELSE 0
              END) AS Questions,
          SUM(CASE
                  WHEN Posts.PostTypeId = 2 THEN 1
                  ELSE 0
              END) AS Answers
   FROM Posts
   GROUP BY Posts.OwnerUserId)
   SELECT
   qAndA.OwnerUserId AS [User Link],
   qAndA.Questions,
   qAndA.Answers
   FROM qAndA
   WHERE (Questions + Answers) > 500

Enter Parameters

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