How many comments do I have for each score.
Q&A for professional and enthusiast programmers
LOG(Score, 10) as score_log10,
ROUND(COUNT(*) / CAST(t.cnt AS FLOAT) * 100.0, 2) as percentage
JOIN (SELECT COUNT(1) AS cnt FROM comments) t
WHERE score >= 10
GROUP BY LOG(Score, 10), t.cnt