COUNT(DISTINCT (date_trunc('month',BLOCK_TIMESTAMP::date))) as "month"

from solana.core.fact_transactions

group by 1)

SELECT case

when "month"=1 then '1 month'

when "month"=2 then '2 month'

when "month"=3 then '3 month'

when "month"=4 then '4 month' else null end as "Activity",

COUNT(DISTINCT walelt) as wallet_sol1

from solanauser

where "Activity" is not null

group by 1