0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for science fiction and fantasy enthusiasts

SELECT TOP 3 u.DisplayName,
        COUNT (c.Id) AS CommentCount,
        COUNT (c.Id)/88709549
FROM Comments AS c
LEFT OUTER JOIN  Users AS u ON c.UserId = u.Id
GROUP BY u.DisplayName
ORDER BY COUNT (c.Id) DESC

fork query

edited jun 4 23

created jun 4 23 jon.doe42064