Query editor
WITH query1 AS (SELECT all_asset_in_usd AS offical_bridge_usdFROM query_3083051LIMIT 1),query2 AS (SELECT total_amount_usd AS np_bridge_usdFROM query_3323395LIMIT 1),official_eth_withdraw AS (SELECT eth_withdraw_usd AS official_bridge_eth_withdraw_usdFROM query_3324804LIMIT 1),official_usdt_withdraw AS (SELECT usdt_withdraw_usd AS official_bridge_usdt_withdraw_usdFROM query_3326993LIMIT 1),official_usdc_withdraw AS (SELECT usdc_withdraw_usd AS official_bridge_usdc_withdraw_usdFROM query_3327010LIMIT 1)SELECTq1.offical_bridge_usd,q2.np_bridge_usd,oew.official_bridge_eth_withdraw_usd,ouw.official_bridge_usdt_withdraw_usd,ocw.official_bridge_usdc_withdraw_usd,(q1.offical_bridge_usd + q2.np_bridge_usd) AS total_bridge_usd,(q1.offical_bridge_usd + q2.np_bridge_usd - oew.official_bridge_eth_withdraw_usd - ouw.official_bridge_usdt_withdraw_usd - ocw.official_bridge_usdc_withdraw_usd) AS total_network_usdFROM query1 q1, query2 q2, official_eth_withdraw oew, official_usdt_withdraw ouw, official_usdc_withdraw ocw-- WITH bridge AS (-- select all_asset_in_usd as offical_bridge_usd from query_3083051 limit 1,-- select total_amount_usd as np_bridge_usd from query_3323395 limit 1-- )-- select * from bridge