CASE WHEN ethereum.core.ez_nft_sales.nft_address = lower('0x86fc6f6c6702ceF7d3BaE87eF41256715416DB71') THEN 'Jadu Ava'

WHEN ethereum.core.ez_nft_sales.nft_address = lower('0xd0f0c40fcd1598721567f140ebf8af436e7b97cf') THEN 'Jadu Jetpack'

WHEN ethereum.core.ez_nft_sales.nft_address = lower('0xeDa3b617646B5fc8C9c696e0356390128cE900F8') THEN 'Jadu Hoverboard'

END AS "Project",

PLATFORM_NAME AS "Marketplace",

COUNT(TX_HASH) AS "Transactions",

to_number(SUM(PRICE_USD),10,2) AS "USD Sales",

SUM(PLATFORM_FEE_USD) AS "Marketplace Fees USD",

SUM(CREATOR_FEE_USD) AS "Creator Fees USD"

FROM ethereum.core.ez_nft_sales

WHERE ethereum.core.ez_nft_sales.nft_address IN (lower('0x86fc6f6c6702ceF7d3BaE87eF41256715416DB71'), lower('0xd0f0c40fcd1598721567f140ebf8af436e7b97cf'), lower('0xeDa3b617646B5fc8C9c696e0356390128cE900F8'))

GROUP BY "Project", "Marketplace"

ORDER BY "Project", "Marketplace"