p.protocol,

p.category,

CONCAT('$', TO_VARCHAR(ROUND(SUM(f.chain_tvl)), '999,999,999,999')) AS "TVL(USD)"

FROM external.defillama.dim_protocols p

JOIN external.defillama.fact_protocol_tvl f

ON p.protocol_id = f.protocol_id

WHERE f.date = CURRENT_DATE() -- Getting latest data

AND p.protocol IN (

'Franklin Templeton',

'LumenSwap',

'Blend',

'Aquarius Stellar',

'Phoenix Defi Hub',

'VNX',

'Soroswap'

GROUP BY 1, 2

ORDER BY 3 DESC;