SELECT
  COALESCE(t.participants.purple_agent, t.participants.white_agent) AS id,
  r.unnest.task_id AS "task_id",
  CASE
    WHEN r.unnest.task_id LIKE '%_l1' THEN 'L1'
    WHEN r.unnest.task_id LIKE '%_l2' THEN 'L2'
    WHEN r.unnest.task_id LIKE '%_l3' THEN 'L3'
    ELSE 'unknown'
  END AS "Auto level",
  COALESCE(r.unnest.solver_backend, 'unknown') AS "backend",
  ROUND(r.unnest.final.normalized_score, 3) AS "final",
  COALESCE(ROUND(r.unnest.purple_agent_runtime_seconds, 3), 0) AS "purple runtime s",
  COALESCE(r.unnest.llm.solver.configured.model, 'unknown') AS "model",
  COALESCE(r.unnest.llm.judge.runtime.model, r.unnest.llm.judge.configured.model, 'unknown') AS "judge model",
  COALESCE(r.unnest.status, 'unknown') AS "status",
  COALESCE(r.unnest.hard_checks_passed, false) AS "hard check passed",
  COALESCE(ROUND(r.unnest.dimension_scores.execution, 3), 0) AS "execution",
  COALESCE(ROUND(r.unnest.dimension_scores.pipeline, 3), 0) AS "pipeline",
  COALESCE(ROUND(r.unnest.dimension_scores.implementation, 3), 0) AS "implementation",
  COALESCE(ROUND(r.unnest.dimension_scores.reasoning, 3), 0) AS "reasoning",
  COALESCE(ROUND(r.unnest.dimension_scores.analysis, 3), 0) AS "analysis",
  COALESCE(ROUND(r.unnest.dimension_scores.validation, 3), 0) AS "validation"
FROM results t
CROSS JOIN UNNEST(t.results) AS r
WHERE r.unnest.task_id IN ('t002_hyy_v5_l1', 't003_hyy_v5_l2', 't004_hyy_v5_l3')
  AND r.unnest.final.normalized_score IS NOT NULL
ORDER BY CASE WHEN COALESCE(r.unnest.solver_backend, 'unknown') = 'unknown' OR COALESCE(r.unnest.llm.solver.configured.model, 'unknown') = 'unknown' OR COALESCE(r.unnest.llm.judge.runtime.model, r.unnest.llm.judge.configured.model, 'unknown') = 'unknown' THEN 1 ELSE 0 END, "final" DESC, id, "task_id";

SELECT
  COALESCE(t.participants.purple_agent, t.participants.white_agent) AS id,
  r.unnest.task_id AS "task_id",
  CASE
    WHEN r.unnest.task_id LIKE '%_l1' THEN 'L1'
    WHEN r.unnest.task_id LIKE '%_l2' THEN 'L2'
    WHEN r.unnest.task_id LIKE '%_l3' THEN 'L3'
    ELSE 'unknown'
  END AS "Auto level",
  COALESCE(r.unnest.solver_backend, 'unknown') AS "backend",
  ROUND(r.unnest.final.normalized_score, 3) AS "final",
  COALESCE(ROUND(r.unnest.purple_agent_runtime_seconds, 3), 0) AS "purple runtime s",
  COALESCE(r.unnest.llm.solver.configured.model, 'unknown') AS "model",
  COALESCE(r.unnest.llm.judge.runtime.model, r.unnest.llm.judge.configured.model, 'unknown') AS "judge model",
  COALESCE(r.unnest.status, 'unknown') AS "status",
  COALESCE(r.unnest.hard_checks_passed, false) AS "hard check passed",
  COALESCE(ROUND(r.unnest.dimension_scores.execution, 3), 0) AS "execution",
  COALESCE(ROUND(r.unnest.dimension_scores.pipeline, 3), 0) AS "pipeline",
  COALESCE(ROUND(r.unnest.dimension_scores.implementation, 3), 0) AS "implementation",
  COALESCE(ROUND(r.unnest.dimension_scores.reasoning, 3), 0) AS "reasoning",
  COALESCE(ROUND(r.unnest.dimension_scores.analysis, 3), 0) AS "analysis",
  COALESCE(ROUND(r.unnest.dimension_scores.validation, 3), 0) AS "validation"
FROM results t
CROSS JOIN UNNEST(t.results) AS r
WHERE r.unnest.task_id IN ('t005_hzz4l_l1', 't006_hzz4l_l2', 't007_hzz4l_l3')
  AND r.unnest.final.normalized_score IS NOT NULL
ORDER BY CASE WHEN COALESCE(r.unnest.solver_backend, 'unknown') = 'unknown' OR COALESCE(r.unnest.llm.solver.configured.model, 'unknown') = 'unknown' OR COALESCE(r.unnest.llm.judge.runtime.model, r.unnest.llm.judge.configured.model, 'unknown') = 'unknown' THEN 1 ELSE 0 END, "final" DESC, id, "task_id";