SELECT Posts.OwnerUserId, COUNT(*) FROM Posts WHERE Posts...

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

SELECT
Posts.OwnerUserId, COUNT(*)
FROM Posts
--JOIN Users on Users.Id = Posts.OwnerUserId
WHERE Posts.Score > 0
  AND Posts.CreationDate >= DATEADD(year,-1,GETDATE())
GROUP BY Posts.OwnerUserId

Enter Parameters

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