SELECT ts.participants.ctf_solver as id, result.challenges_evaluated, (SELECT COUNT(*) FROM UNNEST(result.results) AS c(ch) WHERE c.ch.score >= 1.0) AS challenges_completed_successfully, result.overall_score, (SELECT string_agg(c.ch.challenge, ', ' ORDER BY c.ch.challenge) FROM UNNEST(result.results) AS c(ch)) AS challenges FROM results ts CROSS JOIN UNNEST(ts.results) AS r(result) WHERE result.max_iterations = 5 AND result.include_goal = 'first' AND result.include_tactic = 'first' AND result.include_prerequisites = 'always' AND list_sort(result.history_context) = ['command', 'goal', 'output', 'results'] AND result.task_mode = 'goal' AND result.data_version.version = 'LSX-UniWue/brace-ctf-data@1f2e3cc' GROUP BY id, result ORDER BY challenges, result.overall_score DESC;

SELECT ts.participants.ctf_solver as id, result.challenges_evaluated, (SELECT COUNT(*) FROM UNNEST(result.results) AS c(ch) WHERE c.ch.score >= 1.0) AS challenges_completed_successfully, result.overall_score, (SELECT string_agg(c.ch.challenge, ', ' ORDER BY c.ch.challenge) FROM UNNEST(result.results) AS c(ch)) AS challenges FROM results ts CROSS JOIN UNNEST(ts.results) AS r(result) WHERE result.max_iterations = 5 AND result.include_goal = 'first' AND result.include_tactic = 'first' AND result.include_prerequisites = 'always' AND list_sort(result.history_context) = ['command', 'goal', 'output', 'results'] AND result.task_mode = 'command' AND result.data_version.version = 'LSX-UniWue/brace-ctf-data@1f2e3cc' GROUP BY id, result ORDER BY challenges, result.overall_score DESC;

SELECT ts.participants.ctf_solver as id, result.challenges_evaluated, (SELECT COUNT(*) FROM UNNEST(result.results) AS c(ch) WHERE c.ch.score >= 1.0) AS challenges_completed_successfully, result.overall_score, (SELECT string_agg(c.ch.challenge, ', ' ORDER BY c.ch.challenge) FROM UNNEST(result.results) AS c(ch)) AS challenges FROM results ts CROSS JOIN UNNEST(ts.results) AS r(result) WHERE result.max_iterations = 5 AND result.include_goal = 'first' AND result.include_tactic = 'first' AND result.include_prerequisites = 'always' AND list_sort(result.history_context) = ['command', 'goal', 'output', 'results'] AND result.task_mode = 'anticipated_result' AND result.data_version.version = 'LSX-UniWue/brace-ctf-data@1f2e3cc' GROUP BY id, result ORDER BY challenges, result.overall_score DESC;