nft_address,

case

when nft_address = '0x5663e3e096f1743e77b8f71b5de0cf9dfd058523' then 'Pooly - Judge (POOLY3)'

when nft_address = '0x2a0408ceb664148718e1ef6082acea9fe257ef19' then 'ApeX OG NFT (APEX-OG)'

when nft_address = '0xeb6c5accafd8515c1b9e4c794bdc41532c5543ec' then 'DGFamily (DGFAM)'

when nft_address = '0xa2caea05ff7b98f10ad5ddc837f15905f33feb60' then 'WMasterChef'

when nft_address = '0x06799a1e4792001aa9114f0012b9650ca28059a3' then 'Uniswap V2: Positions NFT (UNI-V2-POS)'

when nft_address = '0xdbe09a801e19c6568c515b0e24cc2337442d4f41' then 'WireNode' --

when nft_address = '0x2b1c7b41f6a8f2b2bc45c3233a5d5fb3cd6dc9a8' then 'KyberSwap v2 NFT Positions Manager (KS2-NPM)' --

when nft_address = '0x4757f744ec0cf2e3500dc655f55100c943a59cbb' then 'short Squeeth (sSQU)' --

else project_name end as nft_projects,

sum (mint_price_usd) as mint_vol,

AVG (mint_price_usd) as avg_vol

from ethereum.core.ez_nft_mints a

left outer join ethereum.core.dim_labels b on a.nft_address = b.address

where mint_price_usd > 0

and block_Timestamp::date BETWEEN '2022-01-01' AND '2022-12-31'

group by 1,2

order by 4 DESC

limit 10