SELECT

FROM_ADDRESS AS user,

COUNT(DISTINCT TX_HASH) AS transaction_count

FROM

ink.core.fact_transactions

WHERE

TX_SUCCEEDED

GROUP BY

FROM_ADDRESS

),

grouped_users AS (

SELECT

CASE

WHEN transaction_count BETWEEN 1 AND 5 THEN '1-5'

WHEN transaction_count BETWEEN 6 AND 10 THEN '6-10'

WHEN transaction_count BETWEEN 11 AND 20 THEN '11-20'

WHEN transaction_count BETWEEN 21 AND 30 THEN '21-30'

WHEN transaction_count BETWEEN 31 AND 40 THEN '31-40'

WHEN transaction_count BETWEEN 41 AND 50 THEN '41-50'

ELSE '51+'

END AS transaction_range,

COUNT(*) AS user_count

FROM

user_transactions

GROUP BY

transaction_range

transaction_range,

user_count

grouped_users

ORDER BY

2;