HA - SQL cleanup 2/2

SELECT
    JSON_EXTRACT(event_data, '$.entity_id') AS entity_id,
    COUNT(*) AS cnt
FROM events
WHERE
    JSON_EXTRACT(event_data, '$.entity_id') IS NOT NULL
GROUP BY
    JSON_EXTRACT(event_data, '$.entity_id')
ORDER BY
    COUNT(*) DESC
LIMIT 10;