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