when protocol ilike '%klayswap%' then 'Klayswap'

when protocol ilike '%swapscanner%' then 'Swapscanner' else protocol end as platform,

sum(chain_tvl) as tvl

from external.defillama.fact_protocol_tvl

where chain in ('Klaytn-staking','Klaytn')

and date = current_date - 1

group by 1

order by 2 desc

limit 10