protocol,

chain,

(SUM(revenue) / (SELECT SUM(revenue) FROM external.defillama.fact_protocol_fees_revenue WHERE chain ILIKE 'solana' AND revenue IS NOT NULL)) * 100 AS RevenuePercentage

FROM

external.defillama.fact_protocol_fees_revenue

WHERE

chain ILIKE 'solana'

AND revenue IS NOT NULL

GROUP BY

protocol, chain

ORDER BY

RevenuePercentage DESC

LIMIT 15;