select count(*) , min ,'optimism' from ( select from_address , min(block_timestamp::date) as min from optimism.core.fact_transactions
where status='SUCCESS'
group by from_address)
where min > '2022-04-18'
group by min
UNION
select count(*) , min ,'arbitrum' from ( select from_address , min(block_timestamp::date) as min from arbitrum.core.fact_transactions
where status='SUCCESS'
group by from_address)
where min > '2022-04-18'
group by min