sum(amount) as unstaked_flow,

avg(amount) as avg_unstake_volume,

count(distinct(tx_id)) as unstake_tx,

count(distinct(delegator)) as unstaker_count,

(unstake_tx/unstaker_count) * 100 as Ratio_unstake_tx_unstaker_count,

(unstaked_flow/unstaker_count) * 100 as Ratio_unstaked_flow_unstaker_count

from flow.core.ez_staking_actions

where tx_succeeded = 'TRUE'

and action in ('DelegatorUnstakedTokensWithdrawn','UnstakedTokensWithdrawn')

GROUP by 1)

SELECT delegator , unstake_tx , unstaked_flow

from t2

order by 2 desc

limit 10