Top Commentors of all time. tptacek is at 1st place with 33839 comments. Hacker news is 12 years old. That's an average of 7 comments per day since inception. Wow #standardSQL SELECT author, count(DISTINCT id) as `num_comments` FROM `bigquery-public-data.hacker_news.comments` WHERE id IS NOT NULL GROUP BY author ORDER BY num_comments DESC LIMIT 100;
Don't use the `comments` table: it was last updated December 2017.
On the full table:
#standardSQL
SELECT
`by`,
COUNT(DISTINCT id) as `num_comments`
FROM `bigquery-public-data.hacker_news.full`
WHERE id IS NOT NULL AND `by` != ''
AND type='comment'
GROUP BY 1
ORDER BY num_comments DESC
LIMIT 100