from flow.core.fact_nft_sales

UNION

select 'ETH' as chain,count (distinct (BUYER_ADDRESS)) as "NFT PURCHASER",count(distinct(seller_address)) AS "NFT SELLERS"

from ethereum.core.ez_nft_sales

UNION

select 'SOLANA' as chain, count(distinct (PURCHASER)) as "NFT PURCHASER", (select count (distinct (SIGNERS)) as "NFT SELLERS"

FROM solana.core.fact_transactions

WHERE TX_ID IN ( SELECT TX_ID FROM solana.core.fact_nft_sales))

FROM solana.core.fact_nft_sales