datavortexzealous-bronze
    Updated 2024-09-13
    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