SELECT results.participants.anomaly_detector AS id, ROUND(r.res.avg_f1 * 100, 1) AS "F1 Score", ROUND(r.res.avg_precision * 100, 1) AS "Precision", ROUND(r.res.avg_recall * 100, 1) AS "Recall", ROUND(r.res.time_used, 1) AS "Time (s)", r.res.campaigns_evaluated AS "Campaigns" FROM results CROSS JOIN UNNEST(results.results) AS r(res) ORDER BY "F1 Score" DESC;