SELECT id, ROUND(AVG(file_acc_mean), 3) AS "File Acc", ROUND(AVG(func_recall_mean), 3) AS "Func Recall", ROUND(AVG(func_precision_mean), 3) AS "Func Precision", ROUND(AVG(line_iou_mean), 3) AS "Line IoU", SUM(n_tasks) AS "# Tasks", ROUND(SUM(time_used), 1) AS "Time (s)" FROM (SELECT results.participants.purple_agent AS id, UNNEST(results.results, recursive := true) AS res FROM results) WHERE file_acc_mean IS NOT NULL GROUP BY id ORDER BY "File Acc" DESC, "Func Recall" DESC, "Line IoU" DESC;