with tab1 as (
select
date_trunc('day', block_timestamp) as date1,
count(*) as Flow_sales
from flow.core.fact_nft_sales
group by 1 )
, tab2 as (
select
date_trunc('day', block_timestamp) as date2,
count(*) as Solana_sales
from solana.core.fact_nft_sales
group by 1 )
select
date1,
Flow_sales,
Solana_sales
from tab1 left outer join tab2 on date1 = date2
where date1 > '2022-04-01'