WITH active_days AS (

SELECT

from_address,

COUNT(DISTINCT block_timestamp::date) AS days,

COUNT(DISTINCT tx_hash) AS total_transactions,

COUNT(DISTINCT block_number) AS blocks,

SUM(tx_fee) AS fees

FROM

monad.testnet.fact_transactions

GROUP BY

1

SELECT

COUNT(DISTINCT from_address) AS users,

CASE

WHEN days = 1 THEN 'a. 1 Day'

WHEN days = 2 THEN 'b. 2 Days'

WHEN days = 3 THEN 'c. 3 Days'

WHEN days = 4 THEN 'd. 4 Days'

WHEN days = 5 THEN 'e. 5 Days'

WHEN days = 6 THEN 'f. 6 Days'

WHEN days = 7 THEN 'g. 7 Days'

WHEN days <= 14 THEN 'h. 1-2 Weeks'

WHEN days <= 21 THEN 'i. 2-3 Weeks'

WHEN days <= 30 THEN 'j. 3-4 Weeks'

WHEN days > 30 THEN 'k. > 1 Month'

END AS breakdown

FROM

active_days

GROUP BY

2

ORDER BY

2 ASC;