SELECT date(block_timestamp)as date1,address,avg(voting_power) as power from terra.validator_voting_power

group by 1,2

limit 100

),

data1 as(

select RANK( )OVER ( PARTITION BY date1 ORDER BY power DESC) as validator ,address from data2

),

data3 as(

SELECT label,vp_address from terra.validator_labels

SELECT * from data3 join data1 on data1.address=data3.vp_address join data2 on data2.address=data3.vp_address where data1.validator<10