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