SELECT results.participants.rita AS id, res.accuracy AS "Accuracy", res.avg_questions_per_instruction AS "Avg Questions / Instruction" FROM results CROSS JOIN UNNEST(results.results) AS r(res);