datavortexzealous-bronze
Updated 2024-09-13
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
27
28
29
30
31
32
›
⌄
WITH distinct_sales_tx AS (
SELECT DISTINCT
tx_id
FROM
sei.nft.ez_nft_sales
WHERE
platform_name = 'pallet'
),
valid_fees AS (
SELECT
tx_id,
CAST(fee AS FLOAT) / 1000000 AS fee_in_sei -- Convert TEXT to FLOAT and then to SEI
FROM
sei.core.fact_transactions
WHERE
tx_id IN (SELECT tx_id FROM distinct_sales_tx)
AND TRY_CAST(fee AS FLOAT) IS NOT NULL -- Ensure valid numeric values
),
summed_fees AS (
SELECT
tx_id,
SUM(fee_in_sei) AS total_fee_in_sei -- Sum fees in SEI per tx_id
FROM
valid_fees
GROUP BY
tx_id
)
SELECT
SUM(total_fee_in_sei) AS total_fees_in_sei -- Sum total fees in SEI across all tx_ids
FROM
summed_fees;
QueryRunArchived: QueryRun has been archived