Posts by High-reputation users

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

/*
SELECT COUNT(*)
FROM Users
WHERE Reputation > 10000;
--28011
*/

WITH HighRepUsers AS (
  SELECT UserId = Id
  FROM Users
  WHERE Reputation > 15
  )
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