hn-heatmaps:再现与HN提交时间与提交分数相关的热图所需的代码和数据

hn-热图 再现将HN提交时间与提交分数相关联的热图所需的代码和数据。 在我的PostgreSQL数据库中使用此SQL查询检索数据，并使用的代码填充了： SELECT date_part('dow', created_at) AS dow, date_part('hour', created_at) As hour, COUNT(created_at) AS num_submissions, AVG(num_points) as avg_score, MEDIAN(num_points) as med_score, CAST(SUM(CASE WHEN num_points >= 10 THEN 1 ELSE 0 END) AS numeric) / COUNT(num_points) as perc_greater_10 FROM hn_submissions GROU