datavortexzany-turquoise
Updated 2024-10-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
WITH protocol_tvl AS (
SELECT
protocol,
SUM(chain_tvl) AS total_chain_tvl
FROM
external.defillama.fact_protocol_tvl
WHERE
chain ILIKE 'solana'
GROUP BY
protocol
)
SELECT
protocol,
total_chain_tvl AS chain_tvl,
RANK() OVER (ORDER BY total_chain_tvl DESC) AS TvlRank
FROM
protocol_tvl
ORDER BY
TvlRank;