SELECT results.participants.agent AS id, ROUND(res.aggregate.weighted_score * 100, 1) AS "Weighted %", ROUND(res.aggregate.pass_rate * 100, 1) AS "Pass Rate %", res.aggregate.correct AS "Correct", res.aggregate.total_tasks AS "Total", ROUND(res.aggregate.avg_latency_ms / 1000, 1) AS "Avg Time (s)" FROM results CROSS JOIN UNNEST(results.results) AS r(res) ORDER BY res.aggregate.weighted_score DESC;

SELECT results.participants.agent AS id, ROUND(res.aggregate.easy_accuracy * 100, 1) AS "Easy %", ROUND(res.aggregate.medium_accuracy * 100, 1) AS "Medium %", ROUND(res.aggregate.hard_accuracy * 100, 1) AS "Hard %", ROUND(res.aggregate.expert_accuracy * 100, 1) AS "Expert %" FROM results CROSS JOIN UNNEST(results.results) AS r(res) ORDER BY res.aggregate.weighted_score DESC;

SELECT results.participants.agent AS id, ROUND(res.aggregate.web_accuracy * 100, 1) AS "Web %", ROUND(res.aggregate.science_accuracy * 100, 1) AS "Science %" FROM results CROSS JOIN UNNEST(results.results) AS r(res) ORDER BY res.aggregate.weighted_score DESC;

SELECT results.participants.agent AS id, ROUND(res.aggregate.web_easy_accuracy * 100, 1) AS "Easy %", ROUND(res.aggregate.web_medium_accuracy * 100, 1) AS "Medium %", ROUND(res.aggregate.web_hard_accuracy * 100, 1) AS "Hard %", ROUND(res.aggregate.web_expert_accuracy * 100, 1) AS "Expert %" FROM results CROSS JOIN UNNEST(results.results) AS r(res) ORDER BY res.aggregate.weighted_score DESC;

SELECT results.participants.agent AS id, ROUND(res.aggregate.science_easy_accuracy * 100, 1) AS "Easy %", ROUND(res.aggregate.science_medium_accuracy * 100, 1) AS "Medium %", ROUND(res.aggregate.science_hard_accuracy * 100, 1) AS "Hard %", ROUND(res.aggregate.science_expert_accuracy * 100, 1) AS "Expert %" FROM results CROSS JOIN UNNEST(results.results) AS r(res) ORDER BY res.aggregate.weighted_score DESC;