WITH bridges_to_aptos AS (
SELECT
CONCAT(source_chain, ' -> Aptos') AS "Bridge To Aptos Route",
COUNT(DISTINCT tx_hash) AS "Bridges To Aptos Count"
FROM
aptos.defi.ez_bridge_activity
WHERE
DATE_TRUNC('month', block_timestamp) = DATE_TRUNC('month', CURRENT_DATE)
AND destination_chain = 'Aptos'
GROUP BY
source_chain
)
SELECT
"Bridge To Aptos Route",
"Bridges To Aptos Count"
FROM
bridges_to_aptos
ORDER BY
"Bridges To Aptos Count" DESC
LIMIT 5;