mehdimarjanTotal Number of NFTs Minted
    Updated 2022-06-22
    WITH mints AS (
    SELECT
    (CASE
    WHEN NFT_ADDRESS = '0x90b3832e2f2ade2fe382a911805b6933c056d6ed' THEN 'Supporter'
    WHEN NFT_ADDRESS = '0x3545192b340f50d77403dc0a64cf2b32f03d00a9' THEN 'Lawyer'
    WHEN NFT_ADDRESS = '0x5663e3e096f1743e77b8f71b5de0cf9dfd058523' THEN 'JUDGE'
    END) AS NFT_NAME,
    MINT_PRICE_ETH, MINT_PRICE_USD, NFT_TO_ADDRESS
    FROM ethereum.core.ez_nft_mints
    WHERE NFT_ADDRESS IN ('0x90b3832e2f2ade2fe382a911805b6933c056d6ed','0x3545192b340f50d77403dc0a64cf2b32f03d00a9','0x5663e3e096f1743e77b8f71b5de0cf9dfd058523')
    )

    SELECT COUNT(*) AS "Number of Mints" FROM mints