SELECT PROJECT_NAME,SUM(PRICE_USD) AS "Volume", COUNT(*) AS "Number",

row_number() over (order by "Volume" DESC) as rank

FROM ethereum.core.ez_nft_sales

WHERE platform_name = 'nftx'

AND BLOCK_TIMESTAMP::DATE < CURRENT_DATE - 60

GROUP BY 1

ORDER BY 2 DESC

LIMIT 3

SELECT SELLER_ADDRESS, BUYER_ADDRESS,

COUNT(BUYER_ADDRESS) AS "Number of Purchases", SUM(PRICE_USD) AS "Total Paid in USD"

FROM ethereum.core.ez_nft_sales

WHERE platform_name = 'nftx'

AND PROJECT_NAME IN (SELECT PROJECT_NAME FROM collections WHERE rank = 1)

AND BLOCK_TIMESTAMP::DATE < CURRENT_DATE - 60

GROUP BY 1, 2

ORDER BY 3 DESC