SELECT
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;