ifnull(c.label,a.validator_address) as to_validator,

amount/pow(10,6) as amt,

from axelar.gov.fact_staking a left outer join axelar.gov.fact_validators b on a.REDELEGATE_SOURCE_VALIDATOR_ADDRESS = b.address

left outer join axelar.gov.fact_validators c on a.VALIDATOR_ADDRESS = c.address

where action = 'redelegate'

and TX_SUCCEEDED = 'TRUE')

select concat(source,'->',to_validator) as validator,

sum(amt) as axl_amount,

avg(amt) as avg_amount,

count(DISTINCT tx_id) as transactions

from validators

group by 1

order by 2 desc

limit 10