Query editor
WITH market AS (SELECT SUM(transactions) AS market_transactions,SUM(borrowed_usd) AS repeated_borrowed_usd,SUM(provider_fee_usd) AS provider_fee_usdFROM "query_8708557"),profit AS (SELECT transactions AS profit_measured_transactions,gross_profit_usd AS verified_gross_profit_usd,gas_cost_usd AS measured_gas_cost_usd,verified_net_profit_usdFROM "query_8708443"WHERE strategy_family = 'TOTAL — verified lower bound')SELECT m.*, p.*,100.0 * p.profit_measured_transactions / m.market_transactions AS profit_measurement_coverage_pctFROM market m CROSS JOIN profit p