SELECT json_extract_string(json_extract(to_json(res.participants), '$.*'), '$[0]') AS id, r.task_id AS "Run ID", ROUND(r.summary.episodes.avg_total_reward, 2) AS "Avg Reward", ROUND(r.summary.episodes.avg_steps, 1) AS "Avg Steps", ROUND(r.summary.episodes.diagnosis_success_rate * 100, 1) AS "Pass Rate %", r.summary.episodes.episodes AS "# Episodes" FROM results AS res, UNNEST(res.results) AS t(r) ORDER BY r.summary.episodes.avg_total_reward DESC, r.summary.episodes.avg_steps ASC;

SELECT json_extract_string(json_extract(to_json(res.participants), '$.*'), '$[0]') AS id, r.task_id AS "Run ID", ROUND(r.summary.episodes.diagnosis_success_rate * 100, 1) AS "Diagnosis %", ROUND(r.summary.episodes.fault_type_macro_f1 * 100, 1) AS "F1 Score %", ROUND(r.summary.episodes.location_accuracy * 100, 1) AS "Location %", r.summary.episodes.episodes AS "# Episodes" FROM results AS res, UNNEST(res.results) AS t(r) ORDER BY r.summary.episodes.diagnosis_success_rate DESC, r.summary.episodes.fault_type_macro_f1 DESC;

SELECT json_extract_string(json_extract(to_json(res.participants), '$.*'), '$[0]') AS id, r.task_id AS "Run ID", ROUND(r.summary.episodes.avg_steps_per_device, 2) AS "Steps/Device", ROUND(r.summary.episodes.cost_efficiency * 100, 1) AS "Cost Eff %", ROUND(r.summary.episodes.tool_cost_index * 100, 1) AS "Tool Cost %", ROUND(r.summary.episodes.topology_coverage * 100, 1) AS "Coverage %" FROM results AS res, UNNEST(res.results) AS t(r) ORDER BY r.summary.episodes.cost_efficiency DESC, r.summary.episodes.avg_steps_per_device ASC;