select --miner as address_of_mine ,
avg(TX_COUNT) as avg_num
from ethereum.core.fact_blocks
where BLOCK_TIMESTAMP >= '2022-9-9'
--GROUP by 1
--order by 2
/*select miner as address_of_mine ,
TX_COUNT as transaction_num
from ethereum.core.fact_blocks
where BLOCK_TIMESTAMP >= '2022-9-9'
and TX_COUNT <= 175.472973
GROUP by 1
order by 2
*/