> With a runaway total of over 7000 posts on Hacker News, Clement Wan averages 2.24 posts a day since Hacker News took off (It's been 3,158 days since Feb 19, 2007). Two very mysterious users appear on this list.
Is this submissions and comments, or just subs, or just comments?
SELECT
author,
COUNT(1) AS c
FROM
[fh-bigquery:hackernews.stories]
WHERE
author IS NOT NULL
GROUP BY
1
ORDER BY
2 DESC
LIMIT
1000
and armed with the knowledge that HN has been in existence for 3158 days, there are 11 people who post strictly more than once a day. They are:
1 cwan 7077
2 shawndumas 6602
3 evo_9 5659
4 nickb 4322
5 iProject 4266
6 bootload 4212
7 edw519 3844
8 ColinWright 3766
9 nreece 3724
10 tokenadult 3659
11 Garbage 3538
Just under 1 a day: robg 3121
Is this submissions and comments, or just subs, or just comments?