permaryprotocol count bsc avax
Updated 2024-11-02
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
⌄
select
count(protocol) as total_protocols,
chain,
category
from external.defillama.fact_protocol_tvl
where (LOWER(chain) LIKE '%bsc%' OR LOWER(chain) = 'avalanche') -- Use LOWER for case insensitivity
AND date BETWEEN '2024-01-01' AND '2024-12-31'
group by chain, category;
select
count(protocol) as total_protocols,
chain
from external.defillama.fact_protocol_tvl
where (LOWER(chain) LIKE '%bsc%' OR LOWER(chain) = 'avalanche') -- Use LOWER for case insensitivity
AND date BETWEEN '2024-01-01' AND '2024-12-31'
group by chain;
QueryRunArchived: QueryRun has been archived