case when nft_address = '0xd1b68763c7170b963ac6ca6b1c2ea25796a18a17' then 'ValHalla Reserve'

when nft_address = '0x33fd426905f149f8376e227d0c9d3340aad17af1' then 'The Memes by 6529'

when nft_address = '0x8bb01a3453f40aea848ec8ccc376d4cc7444530d' then 'JakNFT'

when nft_address = '0x7e9b9ba1a3b4873279857056279cef6a4fcdf340' then 'Noble Cards: Season One'

when nft_address = '0xf36c296e87dd2d7adcef251a542561d4bbe07714' then 'MXFK'

when nft_address = '0xd0485f01e5cf7bab21b3ec9698db6ac331776fee' then 'ANIML'

else coalesce(initcap(project_name), initcap(address_name), nft_address) end project_name ,

count (distinct tx_hash) as Sales_Count,

count (distinct buyer_address) as Buyers_Count,

count (distinct seller_address) as Sellers_Count,

count (distinct tokenid) as Tokens_Count,

count (distinct nft_address) as Collections_Count,

count (distinct platform_name) as Platforms_Count,

sum (price_usd) as Total_Sales_Volume,

avg (price_usd) as Average_Sales_volume,

median (price_usd) as median_sale_volume,

min (price_usd) as minimum_sale_volume,

max (price_usd) as maximum_sale_volume,

sum (tx_fee_usd) as Total_TX_Fee,

avg (tx_fee_usd) as Average_TX_Fee,

median (tx_fee_usd) as Median_TX_Fee

from ethereum.core.ez_nft_sales t1 left outer join ethereum.core.dim_labels t2 on t1.nft_address = t2.address

where origin_to_address = '0xef1c6e67703c7bd7107eed8303fbe6ec2554bf6b'

and price_usd > 0

group by 1,2

order by maximum_sale_volume DESC

limit 10