count(distinct validator_hash) as validators,

count(distinct block_id) as blocks,

count(distinct proposer_address) as proposers,

validators / blocks as average_blocks_per_validator,

blocks / count(distinct date_trunc('day', block_timestamp)) as day_average_blocks_created

from lava.core.fact_blocks

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