2 ms·
Top comment karma users. SQL query: SELECT author, SUM(num_points) AS total_comment_karma, MAX(created_at) AS last_comment FROM hn_comments
by minimaxir 12y ago
Top comment karma users.
SQL query:
SELECT
author,
SUM(num_points) AS total_comment_karma,
MAX(created_at) AS last_comment
FROM hn_comments
GROUP BY author
ORDER BY total_comment_karma DESC
LIMIT 1000