WITH bridger_fees AS (
SELECT
a.sender,
SUM(t.tx_fee) AS total_fees_per_bridger
FROM
avalanche.defi.ez_bridge_activity a
LEFT JOIN
avalanche.core.fact_transactions t
ON
a.tx_hash = t.tx_hash
GROUP BY
a.sender
)
SELECT
AVG(total_fees_per_bridger) AS average_fees_per_bridger
FROM
bridger_fees;