SELECT TOP 500 Id [User Link], Reputation, Questions, Ans...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Mathematics

Q&A for people studying math at any level and professionals in related fields

SELECT TOP 500
  Id [User Link], 
  Reputation,
  Questions,
  Answers
FROM (
  SELECT
    u.Id,
    u.Reputation,
    COUNT(CASE WHEN p.PostTypeId = 1 THEN 1 ELSE NULL END) Questions,
    COUNT(CASE WHEN p.PostTypeId = 2 THEN 1 ELSE NULL END) Answers
  FROM
    Users u
    INNER JOIN Posts p ON u.Id = p.OwnerUserId
  WHERE
    p.PostTypeId IN (1, 2)
  GROUP BY
    u.Id, u.Reputation
  ) x
WHERE
  Answers = 0
ORDER BY
  Reputation DESC, Questions DESC

Enter Parameters

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