select initcap(platform_name) as Marketplace,

coalesce(project_name, address_name, nft_address) as NFT_Project,

count (distinct tx_hash) as Sales_count,

count (distinct buyer_address) as Buyers_count,

count (distinct seller_address) as Sellers_count,

count (distinct nft_address) as Collections_Count,

count (distinct tokenid) as Tokens_Count,

sum (creator_fee_usd) as Total_Royalty_Fees,

avg (creator_fee_usd) as Average_Royalty_Fees,

median (creator_fee_usd) as Median_Royalty_Fees,

sum (price_usd) as Total_USD_Volume,

avg (price_usd) as Average_USD_Volume,

median (price_usd) as Median_USD_Volume,

min (price_usd) as Minimum_USD_Volume,

Max (price_usd) as Maximum_USD_Volume

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

where block_timestamp >= '2022-10-19 04:49:47.000'

group by 1,2

order by 1)

select case when nft_project = '0x05da517b1bf9999b7762eaefa8372341a1a47559' then 'Keepers (KPR)'

when nft_project = '0x942bc2d3e7a589fe5bd4a5c6ef9727dfd82f5c8a' then 'Art Blocks'

when nft_project = '0x6f4388602c5dd6c593bf7c9cf3128aaa2a3e09ce' then 'Tickle'

when nft_project = '0x31fe9d95dde43cf9893b76160f63521a9e3d26b0' then 'Pirate NFT'

when nft_project = '0xf048cbaad26c1a35e7a04e126fdeb9c8045e676b' then 'Wizards of The Tower Shade'

when nft_project = '0x60bb1e2aa1c9acafb4d34f71585d7e959f387769' then 'Art Gobblers'

when nft_project = '0x365d87a8d31c656ed1479c0f54f19e3be9f19537' then 'DuDu Lab'

when nft_project = '0x5802c586f657c787902280ac091d81832d7faf84' then 'Bored y00ts Ape Club'

when nft_project = '0x340700450f0303791529789793909c703730926f' then 'CryptoBirbs'

when nft_project = '0x7bc5d353663c4c94fd022d3df0642b56c174b45c' then 'ChinaChic'

when nft_project = '0x603a481580c8cf85ee169b315653bd9d33c39e52' then 'EveryBodys'

when nft_project = '0x8f6a4d8ad2493adfd7d1540ccdba11bde5c7eb9e' then 'DegenHeim'

when nft_project = '0x671f3b17628b1498db264e8ac77da4e78167ba9e' then 'FreeNFT.xyz'

else initcap(NFT_Project) end as title,