with x as (SELECT

DISTINCT TX_FROM as user,

count(DISTINCT tx_id) as txs

FROM solana.core.fact_transfers

where BLOCK_TIMESTAMP::date >= '{{Starting_date}}'

and

MINT = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'

GROUP by 1)

SELECT count(DISTINCT user) as addresses, case

when txs = 1 then 'A) Only 1 tx'

when txs > 1 and txs < 11 then 'B)2~10 txs'

when txs > 10 and txs < 51 then 'C)11~50 txs'

when txs > 50 and txs < 101 then 'D)51~100 txs'

when txs > 100 and txs < 501 then 'E)101~500 txs'

when txs > 500 then 'F)+500 txs' end as "Activity rate"

from x

GROUP by 2

having "Activity rate" is not null