source_chain,

destination_chain as target_chain,

platform,

count(tx_hash) as total_outbound_txns,

sum(coalesce(AMOUNT_USD, 0)) as total_value_transferred

from crosschain.defi.ez_bridge_activity

where block_timestamp >= current_date - interval '30 days'

and target_chain ='klaytn'

group by destination_chain, platform, source_chain

order by total_value_transferred desc ;