count(distinct tx_hash) as txns

from monad.testnet.fact_transactions

group by 1)

select count(distinct from_address) as "Wallet",

WHEN txns = 1 THEN 'a. 1 txn'

WHEN txns = 2 THEN 'b. 2 txns'

WHEN txns = 3 THEN 'c. 3 txns'

WHEN txns = 4 THEN 'd. 4 txns'

WHEN txns = 5 THEN 'e. 5 txns'

WHEN txns = 6 THEN 'f. 6 txns'

WHEN txns = 7 THEN 'g. 7 txns'

WHEN txns = 8 THEN 'h. 8 txns'

WHEN txns = 9 THEN 'i. 9 txns'

WHEN txns = 10 THEN 'j. 10 txns'

WHEN txns > 10 THEN 'k. > 10 txns' end as breakdown

from base

group by 2

order by 2 asc