WITH sei_native_data AS (

SELECT

COUNT(*) AS total_transactions,

AVG(SPLIT_PART(fee, 'u', 1)::float / POW(10, 6)) AS avg_transaction_fee

FROM sei.core.fact_transactions

WHERE DATE_PART('year', block_timestamp) = 2025

, sei_evm_data AS (

SELECT

COUNT(*) AS total_transactions,

AVG(tx_fee_precise::float) AS avg_transaction_fee

FROM sei.core_evm.fact_transactions

WHERE DATE_PART('year', block_timestamp) = 2025

SELECT

'Sei Native' AS transaction_type,

total_transactions,

avg_transaction_fee

FROM sei_native_data

UNION ALL

SELECT

'Sei EVM' AS transaction_type,

total_transactions,

avg_transaction_fee

FROM sei_evm_data;