How many comments do I have for each score.
Q&A for professional and enthusiast programmers
t.cnt as total,
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 t.cnt