select

tx_hash,

block_timestamp,

from_address as user,

tx_fee

from

mezo.testnet.fact_transactions

where

tx_succeeded

),

tx_counts as (

select

user,

count(*) as tx_count

from

main

group by

user

),

categorized as (

select

user,

tx_count,

case

WHEN tx_count = 1 THEN '🦄 Newcomer (1 TX)'

WHEN tx_count BETWEEN 2 AND 3 THEN '🔸 Occasional User (2-3 TXS)'

WHEN tx_count BETWEEN 4 AND 7 THEN '⚡ Active User (4-7 TXS)'

WHEN tx_count BETWEEN 8 AND 15 THEN '🔥 Regular User (8-15 TXS)'

WHEN tx_count BETWEEN 16 AND 30 THEN '💎 Experienced User (16-30 TXS)'

ELSE '🚀 Power User (31+ TXS)'

end as category

from

tx_counts

),

category_counts as (