WITH transactions AS (

SELECT block_timestamp, block_number, tx_fee, eth_value, status,

to_address, from_address

FROM base.goerli.fact_transactions

),

users AS (

SELECT from_address, COUNT(*) as num_transactions,

SUM(eth_value) as eth_vol, COUNT(DISTINCT to_address) as unique_addresses

FROM transactions

GROUP BY from_address

CASE

WHEN num_transactions BETWEEN 0 AND 9 THEN '1. 0 - 10'

WHEN num_transactions BETWEEN 10 AND 49 THEN '2. 10 - 50'

WHEN num_transactions BETWEEN 50 AND 99 THEN '3. 50 - 100'

WHEN num_transactions BETWEEN 100 AND 199 THEN '4. 100 - 200'

WHEN num_transactions >= 200 THEN '5. >200 '

END as tx, COUNT(*) as num_users

FROM users

GROUP BY tx