0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professionals, academics, and students working within the systems development life cycle

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

fork query

edited nov 2

created nov 1 jon.doe46164