with a as (

select sum(AMOUNT)as vol_stake

from flow.core.ez_staking_actions

where ACTION ='TokensCommitted'

or ACTION ='DelegatorTokensCommitted'

or ACTION ='RewardTokensWithdrawn'

),

b as (

select sum(AMOUNT)as vol_unstake

from flow.core.ez_staking_actions

where ACTION ='UnstakedTokensWithdrawn'

or ACTION ='DelegatorUnstakedTokensWithdrawn'

or ACTION ='DelegatorRewardTokensWithdrawn'

)

select a.vol_stake ,b.vol_unstake ,(a.vol_stake-b.vol_unstake)as Staked

from a join b

select count(TX_ID)

from flow.core.fact_events

where EVENT_TYPE = 'DelegatorTokensStaked'

and TX_SUCCEEDED='TRUE'

,DelegatorTokensStaked,Stake,TokenStaked,TokensStaked

select distinct ACTION

from flow.core.ez_staking_actions