delegation_type,

count(tx_hash) as activity

from optimism.core.fact_delegations

group by delegation_type

order by activity desc