Query editor
SELECTchain,strict_loop_candidates,receiver_reconciled_transactions,profitable_transactions,cost_losing_transactions,reconciliation_coverage,CASE WHEN receiver_reconciled_transactions = 0 THEN NULL ELSE verified_net_profit_usd END AS verified_net_profit_usd,CASE WHEN receiver_reconciled_transactions = 0 THEN NULL ELSE verified_net_profit_per_day END AS verified_net_profit_per_day,CASE WHEN receiver_reconciled_transactions = 0 THEN NULL ELSE average_verified_profit END AS average_verified_profit,CASE WHEN receiver_reconciled_transactions = 0 THEN NULL ELSE median_verified_profit END AS median_verified_profit,CASE WHEN receiver_reconciled_transactions = 0 THEN NULL ELSE p95_verified_profit END AS p95_verified_profit,CASEWHEN receiver_reconciled_transactions = 0 THEN 'Unknown — no reconciled transactions'WHEN reconciliation_coverage < 0.05 THEN 'Very low coverage'WHEN reconciliation_coverage < 0.25 THEN 'Low coverage'WHEN reconciliation_coverage < 0.75 THEN 'Moderate coverage'ELSE 'High coverage'END AS confidence_statusFROM "query_8710910"ORDER BY verified_net_profit_usd DESC NULLS LAST