TRANSFER_TYPE,

COUNT(*) AS number_of_interchain_transactions,

SUM(AMOUNT/(pow(10, decimal))) AS total_value_of_interchain_transfers

axelar.core.fact_transfers

TRANSFER_TYPE != 'AXELAR'

GROUP BY

TRANSFER_TYPE;