SELECT

tx_id,

CAST(REGEXP_REPLACE(fee, '[^0-9]', '') AS FLOAT) / 1000000 AS fee_in_sei

FROM

sei.core.fact_transactions

WHERE

TRY_CAST(REGEXP_REPLACE(fee, '[^0-9]', '') AS FLOAT) IS NOT NULL

AND tx_id IS NOT NULL

),

distinct_sales_tx AS (

SELECT DISTINCT

tx_id

FROM

sei.nft.ez_nft_sales

WHERE

platform_name = 'pallet'

),

joined_fees AS (

SELECT

v.tx_id,

v.fee_in_sei

FROM

valid_fees v

JOIN

distinct_sales_tx s

ON

v.tx_id = s.tx_id

SELECT

SUM(fee_in_sei) AS total_fees_in_sei

FROM

joined_fees;