date(block_timestamp) as date,

count(distinct tx_hash) as nft_txs,

'Ethereum' as chain

from

ethereum.nft.ez_nft_sales

where date(block_timestamp) >= current_date()-90

group by 1

union

select

date(block_timestamp) as date,

count(distinct tx_id) as nft_txs,

'Solana' as chain

from

solana.nft.fact_nft_sales

where date(block_timestamp) >= current_date()-90

group by 1