/*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-01-09'
and TX_COUNT >= 180.383637
GROUP by 1,2
order by 2 desc