select rank , address , label ,
sum(raw_metadata:delegators::integer) as delegators,
avg(raw_metadata:governance_votes::integer) as votes_used,
avg(raw_metadata:percent_power::float) as voting_power,
sum(raw_metadata:power::float) as staked_atom,
sum(raw_metadata:self_stake::integer) as self_stake,
avg(raw_metadata:fee::float) as fee
from cosmos.gov.fact_validators
group by 1,2,3
order by 1
limit 160