WITH total_tx AS (

SELECT blockchain,

COUNT(*) AS total_count

FROM flow.defi.ez_bridge_transactions

WHERE block_timestamp >= '2024-01-01'

AND bridge = 'blocto'

GROUP BY blockchain

SELECT blockchain,

total_count,

(total_count * 100.0 / (SELECT SUM(total_count) FROM total_tx)) AS Tx_percent

FROM total_tx

ORDER BY total_count DESC;