DATE_TRUNC('week', block_timestamp) as "Week",

event_type as "Event Type",

CASE WHEN nft_address = lower('0x86fc6f6c6702ceF7d3BaE87eF41256715416DB71') THEN 'Jadu Ava'

WHEN nft_address = lower('0xd0f0c40fcd1598721567f140ebf8af436e7b97cf') THEN 'Jadu Jetpack'

WHEN nft_address = lower('0xeDa3b617646B5fc8C9c696e0356390128cE900F8') THEN 'Jadu Hoverboard'

END AS "Project",

COUNT(TX_HASH) AS "Transactions",

to_number(SUM(MINT_PRICE_USD),10,0) AS "USD Mint Sales",

to_number("USD Mint Sales"/"Transactions",10,0) as "Avg USD Price",

to_number(SUM(MINT_PRICE_ETH),10,0) AS "Eth Mint Sales",

to_number(SUM(TX_FEE),10,0) AS "Transaction Fees",

MIN(MINT_PRICE_USD) AS "Lowest USD",

MAX(MINT_PRICE_USD) AS "Highest USD"

FROM ethereum.core.ez_nft_mints

WHERE nft_address IN (lower('0x86fc6f6c6702ceF7d3BaE87eF41256715416DB71'), lower('0xd0f0c40fcd1598721567f140ebf8af436e7b97cf'), lower('0xeDa3b617646B5fc8C9c696e0356390128cE900F8'))

GROUP BY "Week", "Event Type", "Project"

ORDER BY "Week"