case when NFT_ADDRESS = '0x0110bb5739a6f82eafc748418e572fc67d854a0f' then'Early Optimists'

when NFT_ADDRESS='0xfa14e1157f35e1dad95dc3f822a9d18c40e360e2'then 'Optimism Quest'

when NFT_ADDRESS='0xac3b9b3f5956b52c448158c0a07ddfa9d5c53a3b'then 'OP Delegatooors'

else PROJECT_NAME

end NFT_collection

from optimism.core.dim_labels join optimism.core.ez_nft_sales on NFT_ADDRESS = address

group by 1 ,2

)

select count (distinct tx_hash) num_sales,

count (distinct SELLER_ADDRESS) num_selelrs,

count (distinct BUYER_ADDRESS) num_buyers,

count (distinct NFT_ADDRESS) num_collections,

count (distinct TOKENID) num_Tokens,

sum (price_usd) volume_usd,

avg (price_usd) avg_volume_usd,

min (price_usd) min_volume_usd,

median (price_usd) median_volume_usd,

max (price_usd) max_volume_usd

from optimism.core.ez_nft_sales

where origin_from_address <> seller_address

and price_usd > 0