WITH minters as (
SELECT TOKENID, BLOCK_TIMESTAMP, MINT_PRICE_ETH, NFT_TO_ADDRESS
FROM ethereum.core.ez_nft_mints
WHERE NFT_ADDRESS = LOWER('0x903E2F5d42EE23156D548DD46bb84B7873789E44')
AND BLOCK_TIMESTAMP < '2022-06-07 17:00:00.000'
)
SELECT
(CASE WHEN BLOCK_TIMESTAMP < '2022-05-05' THEN 'Before PreMint'
ELSE 'After PreMint' END) AS "Minter Status",
COUNT (DISTINCT FROM_ADDRESS) AS "Count"
FROM ethereum.core.FACT_TRANSACTIONS
WHERE FROM_ADDRESS in (SELECT NFT_TO_ADDRESS FROM minters)
GROUP BY 1