3 ms·
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.
by cobookman 8y ago
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;
- minimaxir 8y agoDon'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 tptacek is in first place with 47283 comments.