Team 6Q5. Total Amount of Sales & Creator Fee
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
›
⌄
WITH TokenCreatorFees AS (
SELECT
sales.tokenid AS token_no,
meta.token_name,
SUM(sales.total_fees) as total_sales_eth,
SUM(sales.total_fees_usd) as total_sales_usd,
SUM(sales.creator_fee) AS creator_fee_eth,
SUM(sales.creator_fee_usd) AS creator_fee_usd
FROM
ethereum.nft.dim_nft_metadata meta
JOIN ethereum.nft.ez_nft_sales sales ON sales.tokenid = meta.token_id
WHERE
meta.project_name LIKE '%Moonbirds%'
GROUP BY
meta.token_name,
sales.tokenid,
sales.platform_name
)
SELECT
SUM(total_sales_eth),
SUM(total_sales_usd),
SUM(creator_fee_eth) AS total_creator_fee_eth,
SUM(creator_fee_usd) AS total_creator_fee_usd
FROM TokenCreatorFees;
Run a query to Download Data