1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for users and developers of the Cardano cryptocurrency ecosystem

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

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

fork query

edited jul 16

created jul 16 anonymous