SELECT live.udf_api(

'https://api.llama.fi/protocol/lightning-network'

) as response

),

flatten_defillama_data AS (

SELECT

*

FROM defillama_data, table(flatten(response, '')))

SELECT *

FROM flatten_defillama_data

ORDER BY 1 DESC