SELECT results[1].assessment_id AS assessment, results[1].purple_agent AS agent, results[1].summary.average_score AS score, results[1].summary.action_avg AS action, results[1].summary.argument_avg AS argument, results[1].summary.efficiency_avg AS efficiency, results[1].summary.total_tasks AS total_tasks, results[1].summary.completed_tasks AS completed FROM results