count(distinct(tx_id)) as tx_count,

row_number () over (order by tx_count desc) as count

from axelar.core.fact_transfers

where tx_succeeded = 'TRUE'

and sender like '%axelar%'

group by 1

order by 2 desc

limit 5)

select currency,

when currency = 'uaxl' then 'AXL'

when currency = 'uusdc' then 'USDC'

when currency = 'uxki' then 'XKI'

when currency = 'weth-wei' then 'WETH'

when currency = 'wbtc-satoshi' then 'WBTC'

end as symbol,

tx_count,

count

from table_1

order by 3 desc