SELECT t.participants.agent AS agent_id, elem.scenarios_evaluated, ROUND(elem.evaluation_results.statistics.overall.root_cause_entity_f1.mean * 100, 2) AS rc_entity_f1_pct, ROUND(elem.evaluation_results.statistics.overall.root_cause_entity_precision.mean * 100, 2) AS rc_entity_precision_pct, ROUND(elem.evaluation_results.statistics.overall.root_cause_entity_recall.mean * 100, 2) AS rc_entity_recall_pct, ROUND(elem.evaluation_results.statistics.overall.root_cause_reasoning.mean * 100, 2) AS rc_reasoning_pct, ROUND(elem.evaluation_results.statistics.overall.propagation_chain.mean * 100, 2) AS propagation_chain_pct, ROUND(elem.evaluation_results.statistics.overall.fault_localization_component_identification.mean * 100, 2) AS fault_localization_pct, elem.evaluation_results.statistics.overall.total_bad_runs AS total_bad_runs FROM results t CROSS JOIN UNNEST(t.results) AS u(elem) ORDER BY rc_entity_f1_pct DESC;