protocol,

chain,

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

FROM

external.defillama.fact_protocol_fees_revenue

WHERE

chain ILIKE 'solana'

AND fees IS NOT NULL

GROUP BY

protocol, chain

ORDER BY

FeePercentage DESC

LIMIT 15;