SELECT

tx_hash,

block_timestamp,

from_address AS user,

tx_fee

FROM kaia.core.fact_transactions

),

user_active_days AS (

SELECT

user,

COUNT(DISTINCT DATE(block_timestamp)) AS active_days

FROM main

GROUP BY 1

),

categorized_users AS (

SELECT

CASE

WHEN active_days = 1 THEN '1 Day'

WHEN active_days BETWEEN 2 AND 5 THEN '2-5 Days'

WHEN active_days BETWEEN 6 AND 10 THEN '6-10 Days'

WHEN active_days BETWEEN 11 AND 20 THEN '11-20 Days'

ELSE '21+ Days'

END AS activity_category,

COUNT(DISTINCT user) AS user_count

FROM user_active_days

GROUP BY 1

activity_category,

user_count

FROM categorized_users