B09Fidenza-4
Updated 2023-11-18
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
WITH FidenzaTokens AS (
SELECT distinct(NFT_ADDRESS)
FROM ethereum.nft.dim_nft_collection_metadata
WHERE TOKENID_NAME LIKE 'boonji%'
)
--4. For the Fidenza project, add up all the secondary sale on opensea.
-- List the total secondary sales and estimate the revenue(in eth and USD that the creator has made from commissions.
SELECT
SUM(PRICE) AS Total_Secondary_Sales_ETH,
SUM(CREATOR_FEE) AS Estimated_Creator_Revenue_ETH,
SUM(CREATOR_FEE_USD) AS Estimated_Creator_Revenue_USD
FROM
ethereum.nft.ez_nft_sales
WHERE
TOKENID IN (SELECT TOKENID FROM FidenzaTokens)
AND BUYER_ADDRESS IS NOT NULL
AND PLATFORM_NAME = 'opensea'
AND PRICE > 0; -- Ensure the price is greater than 0 to avoid incorrect calculations
Run a query to Download Data