Query editor
WITH Percentage_CTE AS (SELECT((SUM(TRY_CAST(b.amount AS DOUBLE) / 1E18) / 1E9) * 100) +((27028485.4696564 / 1000000000 * 100) +(199810855.741032 / 1000000000 * 100)) AS Total_PercentageFROMdydx_ethereum.WrappedEthereumDydxToken_evt_Bridge b)SELECTTotal_Percentage,Total_Percentage * 10000000 AS Total_Bridged,(100 - Total_Percentage) AS Total_Unbridged_Percentage,((100 - Total_Percentage) / 100) * 1000000000 AS Total_UnbridgedFROMPercentage_CTE;