with staketable as (
select delegator,
sum (amount) as Staked_Volume
from flow.core.ez_staking_actions
where tx_succeeded = 'TRUE'
and action in ('DelegatorTokensCommitted','TokensCommitted')
group by 1),
unstaketable as (
select delegator,
sum (amount) as UnStaked_Volume
from flow.core.ez_staking_actions
where tx_succeeded = 'TRUE'
and action in ('DelegatorUnstakedTokensWithdrawn','UnstakedTokensWithdrawn')
group by 1)
select t1.delegator,
Staked_Volume - UnStaked_Volume as "Net Staked Volume"
from staketable t1 left outer join unstaketable t2 on t1.delegator = t2.delegator
where Staked_Volume > 0 and "Net Staked Volume" is not null
order by 2 DESC
limit 10