count(DISTINCT(validator_address)) as total_validator, sum(amount/pow(10,6)) as total_axl, avg(amount/pow(10,6)) as avg_amount,

rank() over (order by total_axl desc) as rnk

from axelar.core.fact_staking a join axelar.core.fact_validators b on a.validator_address = b.address

where TX_SUCCEEDED = 'TRUE' and currency = 'uaxl'

and block_timestamp >= '2022-10-01' and action = 'delegate'

group by 1

qualify rnk <= 10