distinct BUYER_ADDRESS as top_purchaser,

count(distinct tx_hash) as sale_no,

sum(PRICE_USD) as volume_usd,

avg(PRICE_USD) as average_volume,

row_number() over (order by volume_usd desc) as rank1

from ethereum.core.ez_nft_sales

where PLATFORM_NAME ='blur'

and PRICE_USD::float > 0

and price>0

and BLOCK_TIMESTAMP>='2022-10-19'

group by 1

order by 3 desc limit 10