Query editor
WITH pumpfun AS (SELECTcreator AS wallet,creator_fee AS fee_lamportsFROM query_5218765),pumpswap AS (SELECTcoin_creator AS wallet,coin_creator_fee AS fee_lamportsFROM query_5218806),combined AS (SELECT wallet, fee_lamports FROM pumpfunUNION ALLSELECT wallet, fee_lamports FROM pumpswap),aggregated AS (SELECTwallet,SUM(fee_lamports) / 1e9 AS total_creator_fee_solFROM combinedGROUP BY wallet)SELECTRANK() OVER (ORDER BY total_creator_fee_sol DESC) AS rank,wallet,total_creator_fee_solFROM aggregatedORDER BY rank