from external.defillama.fact_chain_tvl

where date= current_date -1

and chain in ('Thorchain','Starknet','Cardano','Sei','Kava','Fantom','Klaytn','Injective','Celo','zkSync Era')

union all

select 'Axelar' as chain, round(value:"TVL") as tvl_usd

from (select livequery.live.udf_api('https://flipsidecrypto.xyz/api/v1/queries/407cc25d-ee04-4e75-899c-85c18eeef420/data/latest')

as response), lateral FLATTEN (input => response:data))

select chain, tvl_usd

from tvl_data

order by 2 desc