with resps as
(select defillama.get('/protocols', {}) as resp),
ttvl as (
select
value:category::string as category,
value:tvl::number as tvl
from resps,
lateral flatten (input => resp:data))
select
Category,
sum(tvl) as combined_tvl
from ttvl
where category != 'CEX'
and category != 'Chain'
group by 1
order by 2 desc