with table_1 as (select min(block_timestamp::date) as initial_tx,
proposer
from flow.core.fact_transactions
group by 2),
table_2 as (select b.proposer
from flow.core.fact_transactions a
join table_1 b on a.proposer = b.proposer
where initial_tx < block_timestamp::date = 7),
table_3 as (select count(distinct(proposer)) as total_users
from table_1),
table_4 as (select count(distinct(proposer)) as return_users
from table_2)
select return_users, 'Flow users that have make another transaction within a week'
from table_4
union
select total_users-return_users, 'Flow users that have not make another transaction within a week'
from table_3,table_4