SELECT t.participants."codewalk-qa-agent" AS id, ROUND(AVG(r.result.total_score), 2) AS avg_score, COUNT(*) AS questions FROM results t CROSS JOIN UNNEST(t.results) AS r(result) GROUP BY id ORDER BY avg_score DESC, id;

SELECT t.participants."codewalk-qa-agent" AS id, ROUND(AVG(r.result.scores.architecture_reasoning.score), 2) AS architecture, ROUND(AVG(r.result.scores.reasoning_consistency.score), 2) AS reasoning, ROUND(AVG(r.result.scores.code_understanding_tier.score), 2) AS understanding, ROUND(AVG(r.result.scores.grounding.score), 2) AS grounding FROM results t CROSS JOIN UNNEST(t.results) AS r(result) GROUP BY id ORDER BY id;

SELECT t.participants."codewalk-qa-agent" AS id, r.result.repo_url AS repository, ROUND(AVG(r.result.total_score), 2) AS avg_score, COUNT(*) AS questions FROM results t CROSS JOIN UNNEST(t.results) AS r(result) GROUP BY id, repository ORDER BY id, avg_score DESC;