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

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

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

END AS "Project",

ethereum.core.ez_nft_mints.NFT_TO_ADDRESS AS "Recipient",

COUNT(distinct ethereum.core.ez_nft_mints.TX_HASH) AS "Transactions",

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

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

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

to_number("Eth Mint Sales"/"Transactions",10,2) as "Avg Eth Mint Sale",

to_number(SUM(ethereum.core.ez_nft_mints.TX_FEE),10,2) AS "Transaction Fees",

MIN(MINT_PRICE_USD) AS "Lowest USD",

MAX(MINT_PRICE_USD) AS "Highest USD",

count(distinct ethereum.core.ez_nft_sales.block_number)

FROM ethereum.core.ez_nft_mints

inner join ethereum.core.ez_nft_sales on ethereum.core.ez_nft_mints.NFT_TO_ADDRESS = ethereum.core.ez_nft_sales.seller_address

and ethereum.core.ez_nft_mints.nft_address = ethereum.core.ez_nft_sales.nft_address

and ethereum.core.ez_nft_mints.tokenid = ethereum.core.ez_nft_sales.tokenid

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

GROUP BY "Project", "Recipient"

ORDER BY "Transactions" DESC

select * from ethereum.core.ez_nft_sales

where buyer_address = '0x10a2dfb788a57587e6dead219fb2829b8ead9d7b'

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

select * from ethereum.core.ez_nft_mints

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

limit 10

select *

from ethereum.core.ez_nft_sales

where project_name like '%Jadu%'