case when project_name is null then nft_address else project_name end as projz

from ethereum.core.ez_nft_sales

where date(block_timestamp) >= current_date - 31

and price_usd > 0)

select projz as NFT_collection, platform_name, sum(price_usd) as volume_usd

from raw

where projz in ('wrapped cryptopunks', 'boredapeyachtclub', 'mutantapeyachtclub', 'azuki', 'mineablepunks')

group by 1,2