Question 1

0

Please login or register to vote for this query.

(click on this box to dismiss)

Substrate and Polkadot Meta

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

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results