SELECT

TX_FROM AS wallet,

COUNT(DISTINCT FACT_TRANSACTIONS_ID) AS total_transactions,

CASE

WHEN total_transactions < 20 THEN '20 transactions or less'

WHEN total_transactions >= 20

AND total_transactions < 200 THEN '20-200 transactions'

WHEN total_transactions >= 200

AND total_transactions < 1000 THEN '200-1000 transactions'

ELSE 'Over 1000 transactions'

END as transaction_category

FROM

sei.core.fact_transactions

WHERE

TX_SUCCEEDED = TRUE

AND wallet != ''

GROUP BY

TX_FROM

SELECT transaction_category, COUNT(DISTINCT wallet) as tot_wallet

FROM TransactionCounts

GROUP BY transaction_category