finding top comments

find-top.sql

WITH votes AS (
	SELECT
		number_id,
		id,
		SUM(CAST(plus_one + 1 AS FLOAT)) AS U,
		SUM(CAST(minus_one + 1 AS FLOAT)) AS D
	FROM
		comments
	GROUP BY
		id,
		number_id
)
SELECT
	FORMAT('[%s](https://github.com/golang/go/issues/%s)', number_id, number_id),
	FORMAT('[%s](https://github.com/golang/go/issues/%s#issuecomment-%s)', id, number_id, id),
	U - 1 AS 👍,
	D - 1 AS 👎,
	ABS(0.5 - U / (U + D) - 3.5 * SQRT(U * D / ((U + D) * (U + D) * (U + D + 1)))) + 
	ABS(0.5 - U / (U + D) + 3.5 * SQRT(U * D / ((U + D) * (U + D) * (U + D + 1)))) AS Score
FROM
	votes
ORDER BY
	Score
LIMIT 10;