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
group by 1
order by 2 desc
limit 10