SELECT
    code,
    count(*)
FROM
    data.event_subtypes
GROUP BY 1
ORDER BY 2 DESC;
