Questions and answers by a group of users over time

2

Please login or register to vote for this query.

(click on this box to dismiss)

Chess

Q&A for serious players and enthusiasts of chess

SELECT 
  DATEADD(WEEK, DATEDIFF(WEEK, 0, CreationDate), 0) AS [Week]
  , COUNT(*) AS Count
FROM Posts
WHERE OwnerUserId in (
  209103, -- puf
  394010, -- katowulf
  110915, -- mikelehen
  879295, -- rdimarco
  1373162, -- deast
  5385206 -- sganem
)
GROUP BY DATEADD(WEEK, DATEDIFF(WEEK, 0, CreationDate), 0)
ORDER BY [Week] DESC

Enter Parameters

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