Duplicate questions by score

0

Please login or register to vote for this query.

(click on this box to dismiss)

Science Fiction and Fantasy

Q&A for science fiction and fantasy enthusiasts

WITH Questions AS (SELECT 
  PL.PostId AS [Post Link],
  P.Score AS [Score]
FROM
  PostLinks PL
  INNER JOIN Posts P ON (PL.PostId = P.Id)
WHERE
 PL.LinkTypeId = 3
)

SELECT 
  'All' AS [Score],
  count(*) AS [Count]
FROM Questions

UNION

SELECT
  'Positive' AS [Score],
  count(*)
FROM Questions
WHERE Score > 0

UNION

SELECT
  'Zero' AS [Score],
  count(*) AS [Count]
FROM Questions
WHERE Score = 0

UNION

SELECT
 'Negative' AS [Score],
 count(*) AS [Count]
FROM Questions
WHERE Score < 0

Enter Parameters

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