B092023-12-06 12:49 PM
Updated 2023-12-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
-- Count the number of unique TOKENID for the Fidenza project
WITH FidenzaTokens AS (
SELECT DISTINCT TOKEN_ID
FROM ethereum.nft.dim_nft_collection_metadata
WHERE TOKENID_NAME LIKE 'boonji%'
)
SELECT COUNT(*) AS UniqueTokenIDCount
FROM
ethereum.nft.ez_nft_sales s
JOIN
FidenzaTokens f ON s.TOKENID = f.TOKEN_ID
WHERE
s.BUYER_ADDRESS IS NOT NULL
AND s.PLATFORM_NAME = 'opensea'
AND s.PRICE > 0; -- Ensure the price is greater than 0 to avoid incorrect calculations
Run a query to Download Data