-- forked from Interchain Transfer Success RAte Axelar @ https://flipsidecrypto.xyz/edit/queries/c69de86b-34a4-443a-a752-4529cb4ef65e
SELECT
(COUNT(CASE WHEN TX_SUCCEEDED = TRUE THEN 1 END) * 100.0 / COUNT(*)) AS Transfer_Success_Rate
FROM
axelar.core.fact_transfers
WHERE
transfer_type != 'AXELAR'
AND
DATE_PART(YEAR,BLOCK_TIMESTAMP) = 2024