PROJECT_NAME,

COUNT(DISTINCT BUYER_ADDRESS) AS UniqueBuyers,

COUNT(DISTINCT SELLER_ADDRESS) AS UniqueSellers,

CAST(COUNT(DISTINCT BUYER_ADDRESS) AS FLOAT) / COUNT(DISTINCT SELLER_ADDRESS) AS BuyerSellerRatio

FROM aptos.nft.ez_nft_sales

GROUP BY PROJECT_NAME

limit 10;