with delta_voting_power as(
select
address,
avg(voting_power) as voting_power
from
terra.validator_voting_power
where
block_timestamp > getdate() - interval '1 days'
group by
address
union all
select
address,
- avg(voting_power) as voting_power
from
terra.validator_voting_power
where
block_timestamp > getdate() - interval '61 days'
and block_timestamp < getdate() - interval '60 days'
group by
address
)
select
address,
case when label is not null then label else address end as validator_label,
sum(voting_power) as delta
from
delta_voting_power
left join terra.validator_labels on vp_address = address
group by
address,
validator_label
order by
delta desc