SELECT participants.officeqa_agent AS id, ROUND(SUM(unnest.correct_answers) / SUM(unnest.total_questions) * 100, 1) AS accuracy, SUM(unnest.correct_answers)::INT AS correct, SUM(unnest.total_questions)::INT AS total FROM results, UNNEST(results) GROUP BY participants.officeqa_agent, filename ORDER BY accuracy DESC