nft_address as "NFT Address",

project_name as "NFT Name",

count(tx_hash) as "Total Number of Sales",

sum(price_usd) as "Total Amount of Sales",

("Total Amount of Sales"/"Total Number of Sales") as "Average Amount per Sale",

count(distinct buyer_address) as "Total Unique Buyers"

from ethereum.core.ez_nft_sales

where block_timestamp >= CURRENT_DATE - 60

and platform_name = 'nftx'

and EVENT_TYPE = 'redeem'

group by 1 , 2