select count(distinct TX_ID),sum(AMOUNT/1e6) as sum_amount ,LABEL
from osmosis.core.fact_staking join osmosis.core.dim_labels on osmosis.core.fact_staking.VALIDATOR_ADDRESS=osmosis.core.dim_labels.ADDRESS
where block_timestamp>= '2022-01-01'
and ACTION ='redelegate'
and DELEGATOR_ADDRESS in (select DELEGATOR_ADDRESS from osmosis.core.fact_staking where block_timestamp>= '2022-05-01' and ACTION ='undelegate')
group by LABEL
order by sum_amount desc