SELECT

from_address AS user,

COUNT(DISTINCT TX_HASH) AS tx_count

FROM ronin.core.fact_transactions

GROUP BY from_address

),

transaction_categories AS (

SELECT

tx_count,

CASE

WHEN tx_count < 10 THEN 'Very Low Activity <10'

WHEN tx_count BETWEEN 10 AND 100 THEN 'Low Activity 10-100'

WHEN tx_count BETWEEN 100 AND 500 THEN 'Moderate Activity 100-500'

WHEN tx_count BETWEEN 500 AND 1000 THEN 'High Activity 500-1000'

WHEN tx_count BETWEEN 1000 AND 5000 THEN 'Very High Activity 1000-5000'

ELSE 'Extreme Activity >5000'

END AS category

FROM user_transaction_counts

SELECT

category,

COUNT(*) AS user_count

FROM transaction_categories

GROUP BY category

ORDER BY user_count DESC;