mehdimarjanTotal Number of NFTs Minted
Updated 2022-06-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
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