WITH buyer AS (
SELECT BUYER as buy,
NFT_ID AS id
FROM flow.core.fact_nft_sales
GROUP BY 1,2
),
COUNTe AS (
SELECT COUNT(buy) AS buyer_count
FROM buyer
),
seller AS (
SELECT COUNT(SELLER) AS seller_count
FROM flow.core.fact_nft_sales JOIN buyer ON SELLER = buy AND NFT_ID = id
)
SELECT (seller_count*100)/buyer_count
FROM COUNTe FULL JOIN seller