articoloquintoTop 20 validators by number of re-delagates
    Updated 2022-07-19
    select c."count", l.label as validator from(
    select count(*) as "count", VALIDATOR_ADDRESS as validator
    from osmosis.core.fact_staking
    where block_timestamp >= '2022-01-01'
    and action = 'redelegate'
    and TX_STATUS = 'SUCCEEDED'
    group by 2
    order by 1 desc
    limit 20) as c
    inner join(
    select label, address
    from osmosis.core.dim_labels) as l
    on c.validator = l.address
    order by 1 desc

    Run a query to Download Data