monthname(BLOCK_TIMESTAMP) AS Month,

date_trunc('day', BLOCK_TIMESTAMP)::date AS DAY,

count(BLOCK_ID) as blocks,

86400 /blocks as Avgtimesec

from terra.core.fact_blocks where BLOCK_TIMESTAMP::date between '2022-12-01' and CURRENT_DATE-1

group by 1,2