label,

delegator_shares as total_stake_atom,

sum(delegator_shares) over () as total_staked_atom,

(total_stake_atom/total_staked_atom)*100 as voting_power

from cosmos.core.fact_validators

order by total_stake_atom desc)

select *,

sum(voting_power) over (order by total_stake_atom desc rows between unbounded preceding and current row) as cum_voting_power

from final

limit 20