from ethereum.core.fact_transactions-----i us data in tabale

where block_timestamp::date >= '2022-06-01' and block_timestamp::date < '2022-06-19'

group by 2)

,all_user as ( select min(block_timestamp::date) as date , FROM_ADDRESS

from ethereum.core.fact_transactions---tabel transaction eth

where block_timestamp::date >= '2022-07-01' and block_timestamp::date <= '2022-07-19' and FROM_ADDRESS in ( select FROM_ADDRESS from ETH)

group by 2)

select 'all_user' as type , count(DISTINCT(FROM_ADDRESS)) as total_user----count of transaction all user

from ETH group by 1

UNION select 'activ_User' as type, count(DISTINCT(FROM_ADDRESS)) as total_user-----count 0f transaction active user

from all_user group by 1