select distinct PROPOSER

from flow.core.fact_transactions

where year(block_timestamp)=2022 and month(block_timestamp)=5 and TX_SUCCEEDED='TRUE')

,tblsecondflow as (

select distinct PROPOSER

from flow.core.fact_transactions

where year(block_timestamp)=2022 and month(block_timestamp)=6 and TX_SUCCEEDED='TRUE')

, tblfirstsolana as (

select distinct SIGNERS

from solana.core.fact_transactions

where year(block_timestamp)=2022 and month(block_timestamp)=5 and SUCCEEDED='TRUE')

, tblsecondsolana as (

select distinct SIGNERS

from solana.core.fact_transactions

where year(block_timestamp)=2022 and month(block_timestamp)=6 and SUCCEEDED='TRUE')

, tblfirstethereum as (

select distinct FROM_ADDRESS

from ethereum.core.fact_transactions

where year(block_timestamp)=2022 and month(block_timestamp)=5 and STATUS='SUCCESS')

, tblsecondethereum as (

select distinct FROM_ADDRESS

from ethereum.core.fact_transactions

where year(block_timestamp)=2022 and month(block_timestamp)=6 and STATUS='SUCCESS')

select 'A1. Flow : User made a transaction in May 2022' as label,count(*) from tblfirstflow

union

select 'A2. Flow : User made a transaction in April 2022' as label,count(*) from tblsecondflow

select 'A3. Flow : common User made a transaction in May and April 2022' as label ,count(*) from tblfirstflow where PROPOSER in (select PROPOSER from tblsecondflow)