WITH transactions AS (
SELECT
platform
, COUNT(*) AS Transaction_in
, 0 AS Transaction_out
FROM
crosschain.defi.ez_bridge_activity
WHERE 1=1
AND source_chain = 'base'
GROUP BY
platform
UNION ALL
SELECT
platform
, 0 AS Transaction_in
, COUNT(*) AS Transaction_out
FROM
crosschain.defi.ez_bridge_activity
WHERE 1=1
AND destination_chain = 'base'
GROUP BY
platform
)
SELECT
platform
, SUM(Transaction_in) AS Transaction_in
, SUM(Transaction_out) AS Transaction_out
, SUM(Transaction_in + Transaction_out) AS Total_Transactions
FROM
transactions
GROUP BY
platform
ORDER BY