platform,

COUNT(DISTINCT tx_id) AS transactions,

SUM(amount_usd) AS total_usd_bridged

FROM

flow.defi.ez_bridge_activity

WHERE

(source_chain IN ('Ethereum', 'BSC', 'Polygon', 'Fantom', 'Avalanche', 'Moonbeam', 'Evmos')

OR destination_chain IN ('Ethereum', 'BSC', 'Polygon', 'Fantom', 'Avalanche', 'Moonbeam', 'Evmos'))

AND amount_usd IS NOT NULL

GROUP BY

platform