currency,

count(distinct tx_id) as tx_count

FROM axelar.core.fact_transfers

WHERE TRANSFER_TYPE = 'IBC_TRANSFER_IN'

AND (amount/pow(10,decimal)) is not null

AND TX_SUCCEEDED = 'TRUE'

group by 1

order by 2 DESC

limit 10