Query editor
SELECTSUM(CASE WHEN isCex THEN balance ELSE 0 END) AS cex_balance,SUM(CASE WHEN isDex THEN balance ELSE 0 END) AS dex_balance,SUM(CASE WHEN isStaking THEN balance ELSE 0 END) AS lockedFROM(SELECT isCex, isDex, isStaking, balanceFROM query_4788072UNION ALLSELECT isCex, isDex, isStaking, balanceFROM query_4802588) AS combined;