binhachon114. [Easy] New Validators - Last 60 Days - Validators who has gained the most voting power in the last 60 days
    Updated 2021-12-14
    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

    Run a query to Download Data