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