mucryptoTVL by blockchain/category
    Updated 2024-10-01
    with resps as
    (select defillama.get('/protocols', {}) as resp),

    b as (
    select
    value:category as category,
    value:chainTvls as blockchains
    from resps,
    lateral flatten (input => resp:data)
    where category = 'Governance Incentives'),

    a as (
    select
    *
    from b,
    lateral flatten (input => blockchains))

    select
    key as "BLOCKCHAIN/CATEGORY",
    sum(value) as tvl
    from a
    group by 1
    order by 2 desc
    limit 10
    QueryRunArchived: QueryRun has been archived