from optimism.core.fact_transactions

where BLOCK_TIMESTAMP::date >= '2022-01-01' and BLOCK_TIMESTAMP::date < '2022-12-25'

and FROM_ADDRESS not in (select DISTINCT ADDRESS from optimism.core.dim_labels ) )

,

t1 as (SELECT DISTINCT FROM_ADDRESs as wallet, BLOCK_TIMESTAMP

from optimism.core.fact_transactions

where BLOCK_TIMESTAMP::date >= '2022-12-25'

and BLOCK_TIMESTAMP::date < '2023-01-06'

and FROM_ADDRESS not in (SELECT DISTINCT wallet from oldw)

and FROM_ADDRESS not in (select DISTINCT ADDRESS from optimism.core.dim_labels ) ) ,

tx as (SELECT DISTINCT wallet, min(BLOCK_TIMESTAMP) as days

from t1

group by 1

) ,

t2 as (SELECT DISTINCT wallet

from tx ),

tb1 as (select

DISTINCT from_address,

count (tx_hash) as txs

from optimism.core.fact_transactions

where BLOCK_TIMESTAMP::date >= '2022-12-25'

and BLOCK_TIMESTAMP::date < '2023-01-06'

and from_address in (select DISTINCT wallet from t2)

GROUP by 1)

select

case when txs =1 then 'Only 1 Transaction'

when txs>=2 and txs<10 then 'Between 2~9 Trnsactions'

when txs>=10 and txs<50 then 'Between 10~49 Transactions'

when txs>=50 and txs<100 then 'Between 50~99 Transactions'