with a as(select
date_trunc('day',block_timestamp) date,
count(tx_id) flow_sales
from flow.core.fact_nft_sales
where date >='2022-01-01'
group by DATE
),b as(
select
date_trunc('day',block_timestamp) date,
count(tx_id) solana_sales
from solana.core.fact_nft_sales
where date>='2022-01-01'
group by date
),c as(
select
date_trunc('day',block_timestamp) date,
count(tx_hash) ethereum_sale
from ethereum.core.ez_nft_sales
where date>='2022-01-01'
group by date
)
select a.date,flow_sales,solana_sales,ethereum_sale
from a
join b on a.date=b.date
join c on a.date=c.date