upper(iff(nft_address = '0x60bb1e2aa1c9acafb4d34f71585d7e959f387769', 'Art Gobblers', project_name)) as project_name,

count(distinct(tx_hash)) as tx_num,

count(distinct(buyer_address)) as buyers_num,

count(distinct(seller_address)) as sellers_num,

count(distinct(tokenid)) as tokens_num,

sum(price_usd) as total_volume_usd,

avg(price_usd) as average_volume_usd,

median(price_usd) as median_volume_usd,

min(price_usd) as min_volume_usd,

max(price_usd) as max_volume_usd

from ethereum.core.ez_nft_sales

where 1 = 1

and nft_address in (

'0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb',

'0xbc4ca0eda7647a8ab7c2061c2e118a18a936f13d',

'0x49cf6f5d44e70224e2e23fdcdd2c053f30ada28b',

'0x60bb1e2aa1c9acafb4d34f71585d7e959f387769'

)

and price_usd > 0

group by 1

order by tx_num desc