hess2024-03-08 03:43 PM
    Updated 2025-01-22
    select chain,
    case when chain = 'Sei' then 'Sei' else 'Other chains' end as type,
    max(tvl_usd) as max
    from external.defillama.fact_chain_tvl
    where chain in ('Sei','Base','Avalanche','Arbitrum','Polygon','Aptos','Optimism')
    and date = current_date
    group by 1,2
    QueryRunArchived: QueryRun has been archived