registry_type,

count(*) as count

from crosschain.olas.dim_registry_metadata

group by registry_type

order by count desc;