CONTRACT_NAME,

BRIDGE,

COUNT(DISTINCT TX_ID) AS "Transactions",

SUM(AMOUNT) AS "Amount"

FROM flow.core.fact_bridge_transactions

left join flow.core.dim_contract_labels ON TOKEN_CONTRACT = EVENT_CONTRACT

GROUP BY 1,2