HA - SQL cleanup 1/2

SELECT
    entity_id,
    COUNT(*) AS cnt
FROM states
GROUP BY
    entity_id
ORDER BY
    COUNT(*) DESC
LIMIT 10;