SELECT name, COUNT(*) AS tencount
FROM persons
where score = 10
GROUP BY name;