Number of questions/answers for users from the given list

1

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Different

Q&A for power users of Apple hardware and software

SELECT
  u.Id AS [User Link],
  SUM(case when p.PostTypeId = 1 then 1 else 0 end) AS [Questions],
  SUM(case when p.PostTypeId = 1 then 1 else 0 end) AS [Question Score],
  SUM(case when p.PostTypeId = 2 then 1 else 0 end) AS [Answers],
  SUM(case when p.PostTypeId = 2 then 1 else 0 end) AS [Answer Score],
  u.Reputation
FROM Posts p INNER JOIN USERS u ON (p.OwnerUserId=u.Id)
WHERE p.OwnerUserId IN(##list?5101,7206,20302,45250,80790,92164,120914,124904##)
GROUP BY u.Id, u.Reputation
ORDER BY u.Id

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results