Query editor
WITH creator_fees_raw AS (SELECT * FROM query_5218806),avg_price AS (SELECT AVG(price) AS avg_sol_to_usdFROM prices.usdWHERE symbol = 'SOL'AND DATE_TRUNC('day', minute) >= DATE '2025-05-11'),fees_converted AS (SELECTSUM(coin_creator_fee) / 1e9 AS total_creator_fees_solFROM creator_fees_raw)SELECT'Creator Revenue Fees (SOL)' AS fee_type,f.total_creator_fees_sol AS sol_amount,f.total_creator_fees_sol * p.avg_sol_to_usd AS usd_equivalentFROM fees_converted f, avg_price p;