SUM(total_fees) AS overall_total_fees

FROM (

SELECT

DATE_TRUNC('week', a.block_timestamp) AS week,

SUM(t.tx_fee) AS total_fees

FROM

avalanche.defi.ez_bridge_activity a

LEFT JOIN

avalanche.core.fact_transactions t

ON

a.tx_hash = t.tx_hash

GROUP BY

DATE_TRUNC('week', a.block_timestamp)

) AS weekly_fees;