Q&A for developers building blockchains with the Substrate SDK
SELECT TOP 15 Users.Id AS UserId, COUNT(Posts.Id) AS PostCount FROM Posts JOIN Users ON Posts.OwnerUserId = Users.Id WHERE Users.Id != -1 GROUP BY Users.Id ORDER BY PostCount DESC;