proposer_address as validator,

count(distinct block_id) as blocks

from lava.core.fact_blocks

where block_timestamp::date >= '2024-07-30'

group by 1

order by 2 desc

limit 10