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
Hacker news is 12 years old. That's an average of 7 comments per day since inception. Wow