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. Solana : User made a transaction in May 2022' as label,count(*) from tblfirstsolana

union

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

select 'A3. Solana : common User made a transaction in May and April 2022' as label ,count(*) from tblfirstsolana where SIGNERS in (select SIGNERS from tblsecondsolana)