as (select proposer as users,

count(distinct tx_id) as num_transaction

from flow.core.fact_transactions

where TX_SUCCEEDED='TRUE'

and block_timestamp>='2022-07-01'

group by 1)

select case

when num_transaction=1 then 'Interaction'

when num_transaction>1 then 'Interact again'

end as buckets,

count(distinct users) as count_users

from tb1

group by 1