epoch_id,

max(block_timestamp) as epoch_time,

count(distinct block_author) as validators,

avg(CHUNKS_INCLUDED) as average_chunks,

validators/average_chunks as validators_to_shards_ratio,

max(chunks_included) as shards_or_houses

from near.core.fact_blocks

group by epoch_id

order by epoch_time desc