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