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 u.DisplayName,
       COUNT (c.Id) AS CommentCount,
       ROUND(COUNT (c.Id)*100/(SELECT COUNT(*) FROM Comments), 1) AS PercentageTotal
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

view current version

edited jun 4

created jun 4 jon.doe42064