How many did each user asked questions and gave answers

0

Please login or register to vote for this query.

(click on this box to dismiss)

Physics

Q&A for active researchers, academics and students of physics

/* How much each user asked questions and gave answers

Random sample of users is taken (for research).

PostTypeId = 1 is question
PostTypeId = 2 is answer
*/


;WITH UsersSample AS
(
  SELECT u.Id
  FROM Users u tablesample(1 percent)
  )
  SELECT p.PostTypeId, p.OwnerUserId, p.OwnerUserId AS [User Link],
  COUNT(*) as n
FROM Posts p
RIGHT OUTER JOIN UsersSample u ON u.Id = p.OwnerUserId
WHERE p.OwnerUserId > 0
GROUP BY p.OwnerUserId, p.PostTypeId
ORDER BY p.OwnerUserId, p.PostTypeId

Enter Parameters

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