select

case

when nft_address = '0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb' then 'Cryptopunks'

when nft_address = '0xbc4ca0eda7647a8ab7c2061c2e118a18a936f13d' then 'BAYC'

end as collection,

count(price) as "Total Transactions",

sum(creator_fee) as "Total Royalties Generated (ETH)",

sum(price) as "Total Volume (ETH)"

from ethereum.core.ez_nft_sales

where nft_address in ('0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb' , '0xbc4ca0eda7647a8ab7c2061c2e118a18a936f13d')

group by collection