when velo_action = 'deposit' and deposit_type = '1' then 'Create Lock'

when velo_action = 'deposit' and deposit_type = '2' then 'Increase Amount'

when velo_action = 'deposit' and deposit_type = '3' then 'Increase Unlock Duration'

when velo_action = 'deposit' and deposit_type = '4' then 'Merge' else velo_action end as type,

count (distinct tx_hash),

count (distinct origin_from_address),

sum (velo_amount_usd),

avg (velo_amount_usd)

from optimism.velodrome.ez_velo_locks

group by 1