SELECT DISTINCT Date_trunc('day',BLOCK_TIMESTAMP) AS Date, TX_FROM

FROM osmosis.core.fact_transactions

),

t2 AS (

SELECT Date_trunc('week',date) AS week, TX_FROM, Count(*) AS Active_days

FROM t1

GROUP BY 1,2

),

t3 AS(

SELECT week, Active_days, count(*) AS days_of_activeness

FROM t2

GROUP By 1,2)

SELECT week, days_of_activeness,IFF(Active_days=1,'Active For 1 day',CONCAT('Active for ',Active_days,' days')) AS Active_days

FROM t3