(SELECT

DISTINCT address as address,

AVG(voting_power) as avg_voting_power

FROM terra.validator_voting_power

WHERE

block_timestamp >= getdate() - interval '7 days'

GROUP BY 1

ORDER BY 2 DESC),

total as (

SELECT

AVG(total_staked) as total_staked_balance

FROM (

SELECT

date,

SUM(balance) as total_staked

FROM terra.daily_balances

WHERE

balance_type='staked'

AND

lower(currency)='luna'

GROUP BY 1

ORDER BY 1 DESC)

WHERE

date >= getdate() - interval '7 days')

address,

avg_voting_power,

total_staked_balance,

avg_voting_power/total_staked_balance as perc_voting

FROM by_validator

OUTER JOIN total

ORDER BY 2 DESC

LIMIT 25