OneDataAnalystHow many wallets mint 2 nfts
Updated 2022-07-29
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
WITH first_Mint AS (
SELECT MIN(BLOCK_TIMESTAMP) AS Fist_Mint, NFT_TO_ADDRESS AS Address1
FROM ethereum.core.ez_nft_mints
WHERE NFT_ADDRESS = '0xdfb57b6e16ddb97aeb8847386989f4dca7202146'
GROUP BY 2),
second_Mint AS (
SELECT MAX(BLOCK_TIMESTAMP) AS second_Mint, NFT_TO_ADDRESS AS Address2
FROM ethereum.core.ez_nft_mints
WHERE NFT_ADDRESS = '0xdfb57b6e16ddb97aeb8847386989f4dca7202146'
GROUP BY 2),
Mintcounts AS (
SELECT NFT_TO_ADDRESS AS address , COUNT(NFT_TO_ADDRESS) AS Mint_COUNT
FROM ethereum.core.ez_nft_mints
WHERE NFT_ADDRESS = '0xdfb57b6e16ddb97aeb8847386989f4dca7202146'
GROUP BY 1)
SELECT count(Address)
FROM Mintcounts
WHERE Mint_COUNT = 2
Run a query to Download Data