SELECT

chain,

chains,

description,

protocol,

protocol_id

FROM external.defillama.dim_protocols

),

count_prot AS (

SELECT

chain,

count(protocol) AS num_protocols

FROM all_prot

GROUP BY 1

),

filt_prot AS (

SELECT

*

FROM count_prot

WHERE num_protocols >= 7

),

all_tvl AS (

SELECT

date,

chain,

tvl_usd

FROM external.defillama.fact_chain_tvl

WHERE date = CURRENT_DATE()

and tvl_usd > 10000000

AND tvl_usd < 100000000