1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for power users of Apple hardware and software

SELECT TOP(##num?100##)
  OwnerUserId AS [User Link], OwnerDisplayName, COUNT(Id) AS [Count]
FROM Posts
WHERE (CommunityOwnedDate IS NOT NULL)
GROUP BY OwnerUserId, OwnerDisplayName
ORDER BY COUNT(Id) DESC

fork query

edited may 5 22

created jul 31 19 Martin20528