seller_address as seller,

count(distinct(tx_hash)) as txn_number,

count(distinct(tokenid)) as lands_number,

count(distinct buyer_address) as purchasers_number,

txn_number/purchasers_number as tx_per_purchaser,

sum(price_usd) as volume_usd,

avg(price_usd) as volume_avg,

median(price_usd) as volume_median,

max(price_usd) as volume_max

from ethereum.core.ez_nft_sales

where block_timestamp::date >= current_date - interval '3 months'

and nft_address = '0x5cc5b05a8a13e3fbdb0bb9fccd98d38e50f90c38'

group by 1

order by volume_usd desc

limit 20