datavortexPercentage Contribution of Revenue by Protocol to Total Revenue:
    Updated 2025-02-27
    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;

    QueryRunArchived: QueryRun has been archived