Q&A for developers building blockchains with the Substrate SDK
SELECT TOP 15 U.ID, U.DisplayName, COUNT(P.ID) as NumberofPosts FROM USERS U JOIN POSTS P ON U.ID = P.OwnerUserID GROUP BY U.ID, U.DisplayName ORDER BY COUNT(P.ID) DESC