LEFT(case when transfer_type LIKE 'IBC_TRANDFER_OUT' then sender else RECEIVER end, POSITION('1' IN case when transfer_type LIKE 'IBC_TRANDFER_OUT' then sender else RECEIVER end) - 1) as other_chain,

count(*) as transactions,

count(DISTINCT

CASE when transfer_type LIKE 'IBC_TRANDFER_OUT' then sender else RECEIVER end

) as users

FROM axelar.core.fact_transfers

WHERE transfer_type LIKE '%IBC%'

AND block_timestamp > '2023-09-20'

AND NOT other_chain LIKE 'axelar'

GROUP BY 1