I don't understand here Database schema documentation for the public data dump and SEDE the meaning of comments.score. Because I don't see any comment that has a score. So this means it is trivial field?
In this screenshot I indicated what Comments.Score is:
And you can verify with this query that the results match.
There are a lot of comments and there are also a heck of a lot of comments with no score. I've created this query with three result sets, one which produces a graph, because a picture says more than a thousands words. It shows on the x-axis the score and on the y-xis the Log10 of the count for that score, as well as the length and # days in the same scale.
The second and third result set return the oldest zero-scored comment
serialize()can be pretty useful for that as well. I think the trick to coming up with a viable system is finding some way to index the data nodes without killing yourself with complexity.
and the highest scored comment:
(all on Stack Overflow)