SELECT

PLATFORM_NAME,

PROJECT_NAME,

COUNT(TX_HASH) AS transactions_number,

COUNT(DISTINCT BUYER_ADDRESS) AS buyer_number,

COUNT(DISTINCT SELLER_ADDRESS) AS seller_number,

COUNT(DISTINCT NFT_ADDRESS) AS nft_number,

SUM(TOTAL_PRICE_USD) AS sales_volume,

SUM(PLATFORM_FEE_USD) AS platform_fee_usd

FROM

aptos.nft.ez_nft_sales

GROUP BY

PLATFORM_NAME, PROJECT_NAME

PLATFORM_NAME,

transactions_number,

buyer_number,

seller_number,

nft_number,

sales_volume,

platform_fee_usd,

tab1

ORDER BY

transactions_number DESC;