Posts from users that have high rep today

0

Please login or register to vote for this query.

(click on this box to dismiss)

Lifehacks

Q&A for people looking to bypass life's everyday problems with simple tricks

WITH HighRepUsers AS (
  SELECT UserId = Id
  FROM Users
  WHERE Reputation > 1000
  )
SELECT PostYear         = DATEPART(YEAR,p.CreationDate), 
       TotalPostCount   = COUNT(*),
       HighRepUserPosts = COUNT(u.UserId)
FROM Posts p
LEFT JOIN HighRepUsers u ON u.UserId = p.OwnerUserId
GROUP BY DATEPART(YEAR,p.CreationDate)
ORDER BY PostYear

Enter Parameters

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