strawbettynumber of delegator of validator of terra network
    Updated 2022-03-25
    with tab1 as(
    select label
    from terra.labels
    where label_subtype='validator'),
    tab2 as (select validator_address_label,delegator_address,block_timestamp::date as date
    from terra.staking)
    select tab1.label,count(tab2.delegator_address) as number_of_delegator,tab2.date
    from tab1
    left join tab2
    on tab1.label=tab2.validator_address_label
    where date=current_date
    group by 1,3
    order by 2 desc
    limit 15


    Run a query to Download Data