delegator_address, count(DISTINCT validator_address) as Validator_Count

from terra.staking

where tx_status = 'SUCCEEDED' and action = 'delegate'

group by 1

order by 2 desc)

avg(validator_count) as Average

from counts