select

sum (amount) as FLOW,

avg (amount) as FLOW_AVG,

median (amount) as MEDIAN,

count (distinct tx_id) as TRXS,

count (distinct delegator) as Users,

case when action in ('DelegatorTokensCommitted','TokensCommitted') then 'Stake'

end as TYPE,

min (amount) as MIN,

max (amount) as MAX

from flow.core.ez_staking_actions

where tx_succeeded = 'TRUE' AND TYPE IS NOT NULL

group by TYPE