--credit : misaghlb
with all_data as (
select
LP_PROVIDER_ADDRESS,
count(distinct tx_hash) as tx_count
from optimism.velodrome.ez_staking_actions
where STAKING_ACTION_TYPE = 'deposit'
group by LP_PROVIDER_ADDRESS
)
select
case when tx_count = 1 then '1 Transaction'
when tx_count > 1 and tx_count <= 5 then '2 - 5 Transactions'
when tx_count > 5 and tx_count <= 10 then '6 - 10 Transactions'
else 'More Than 10 Transactions' end as type,
count (distinct LP_PROVIDER_ADDRESS) as delegators
from all_data
group by type