SELECT
  t.participants.white_agent AS id,
  r.unnest.final.normalized_score AS "Final Score"
FROM results t
CROSS JOIN UNNEST(t.results) AS r
WHERE r.unnest.final.normalized_score IS NOT NULL;

SELECT
  t.participants.white_agent AS id,
  ROUND(AVG(CASE WHEN r.unnest.hard_checks_passed THEN 1 ELSE 0 END) * 100, 1) AS "Hard Check Pass %"
FROM results t
CROSS JOIN UNNEST(t.results) AS r
WHERE r.unnest.task_id IS NOT NULL
GROUP BY id;

SELECT
  t.participants.white_agent AS id,
  ROUND(ABS(r.unnest.signals."fit_result.mu" - 91.2), 3) AS "|μ − 91.2|"
FROM results t
CROSS JOIN UNNEST(t.results) AS r
WHERE r.unnest.signals."fit_result.mu" IS NOT NULL;