with tab1 as(
select address, label
from terra.labels
where label_subtype='validator'
and address_name='vp_address'),
tab2 as(select voting_power, address,block_timestamp::date as date
from terra.validator_voting_power
)
select tab1.label,avg(tab2.voting_power)as avg_vot_power,tab2.date
from tab1
left join tab2
on tab1.address=tab2.address
where date=current_date
group by 1,3
order by 2 desc
limit 15