with acquired_eth_users AS

select 'ethereum' as chain , from_address, sum(1) as "yes" from ethereum.core.fact_transactions

where 1=1

and nonce =1

and block_timestamp >= '2023-01-01'

and block_timestamp < '2024-01-01'

group by 1,2 )

select distinct from_address,'ethereum' as chain, 1 as "yes" from acquired_eth_users

),

acquired_poly_users_chain as

with acquired_poly_users AS

select 'polygon' as chain , from_address, sum(1) as "yes" from polygon.core.fact_transactions

where 1=1

and nonce =1

and block_timestamp >= '2023-01-01'

and block_timestamp < '2024-01-01'

group by 1,2 )

select distinct from_address,'polygon' as chain, 1 as "yes" from acquired_poly_users

),

acquired_opti_users_chain as

with acquired_opti_users AS

select 'optimism' as chain , from_address, sum(1) as "yes" from optimism.core.fact_transactions

where 1=1

and nonce =1

and block_timestamp >= '2023-01-01'