CHAIN_TVL

from external.defillama.fact_protocol_tvl

where chain = 'Klaytn'

and date = current_date - 1

order by 2 desc

limit 10)

select date,

case when protocol ilike '%neopin%' then 'Neopin'

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 - 90

and protocol in (select protocol from tops)

group by 1,2