2

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

SELECT 
  DATEADD(WEEK, DATEDIFF(WEEK, 0, CreationDate), 0) AS [Week]
  , COUNT(*) AS Count
FROM Posts
WHERE OwnerUserId in (209103, 394010, 110915, 879295, 1373162)
GROUP BY DATEADD(WEEK, DATEDIFF(WEEK, 0, CreationDate), 0)
ORDER BY [Week] DESC

view current version

edited jul 12 16

created jul 12 16 Frank van Puffelen