SELECT id, score AS Score, created_at AS Run_Date, composition AS Composition, probability AS Probability, completeness AS Completeness, aesthetics AS Aesthetics, originality AS Originality, fairness AS Fairness, fun AS Fun, difficulty AS Difficulty FROM (SELECT results.participants.agent AS id, unnest(results.results).score AS score, unnest(results.results).created_at AS created_at, unnest(results.results).task_rewards.composition AS composition, unnest(results.results).task_rewards.probability AS probability, unnest(results.results).task_rewards.completeness AS completeness, unnest(results.results).task_rewards.aesthetics AS aesthetics, unnest(results.results).task_rewards.originality AS originality, unnest(results.results).task_rewards.fairness AS fairness, unnest(results.results).task_rewards.fun AS fun, unnest(results.results).task_rewards.difficulty AS difficulty FROM results) ORDER BY Run_Date DESC;

SELECT id, COUNT(*) AS Total_Runs, MAX(score) AS Best_Score, arg_max(composition, score) AS Composition, arg_max(probability, score) AS Probability, arg_max(completeness, score) AS Completeness, arg_max(aesthetics, score) AS Aesthetics, arg_max(originality, score) AS Originality, arg_max(fairness, score) AS Fairness, arg_max(fun, score) AS Fun, arg_max(difficulty, score) AS Difficulty FROM (SELECT results.participants.agent AS id, unnest(results.results).score AS score, unnest(results.results).task_rewards.composition AS composition, unnest(results.results).task_rewards.probability AS probability, unnest(results.results).task_rewards.completeness AS completeness, unnest(results.results).task_rewards.aesthetics AS aesthetics, unnest(results.results).task_rewards.originality AS originality, unnest(results.results).task_rewards.fairness AS fairness, unnest(results.results).task_rewards.fun AS fun, unnest(results.results).task_rewards.difficulty AS difficulty FROM results) GROUP BY id ORDER BY Best_Score DESC;

SELECT id, Run_Date, AVG(score) AS TopK_Avg_Score, AVG(composition) AS TopK_Avg_Composition, AVG(probability) AS TopK_Avg_Probability, AVG(completeness) AS TopK_Avg_Completeness, AVG(aesthetics) AS TopK_Avg_Aesthetics, AVG(originality) AS TopK_Avg_Originality, AVG(fairness) AS TopK_Avg_Fairness, AVG(fun) AS TopK_Avg_Fun, AVG(difficulty) AS TopK_Avg_Difficulty FROM (SELECT id, created_at AS Run_Date, score, composition, probability, completeness, aesthetics, originality, fairness, fun, difficulty, ROW_NUMBER() OVER (PARTITION BY id, created_at ORDER BY score DESC) as rn FROM (SELECT results.participants.agent AS id, res.created_at, map_res.score, map_res.task_rewards.composition, map_res.task_rewards.probability, map_res.task_rewards.completeness, map_res.task_rewards.aesthetics, map_res.task_rewards.originality, map_res.task_rewards.fairness, map_res.task_rewards.fun, map_res.task_rewards.difficulty FROM results CROSS JOIN UNNEST(results.results) AS t(res) CROSS JOIN UNNEST(res.history) AS h(map_res))) WHERE rn <= 5 GROUP BY id, Run_Date ORDER BY Run_Date DESC

SELECT id, Run_Date, AVG(score) AS TopK_Avg_Score, AVG(composition) AS TopK_Avg_Composition, AVG(probability) AS TopK_Avg_Probability, AVG(completeness) AS TopK_Avg_Completeness, AVG(aesthetics) AS TopK_Avg_Aesthetics, AVG(originality) AS TopK_Avg_Originality, AVG(fairness) AS TopK_Avg_Fairness, AVG(fun) AS TopK_Avg_Fun, AVG(difficulty) AS TopK_Avg_Difficulty FROM (SELECT id, created_at AS Run_Date, score, composition, probability, completeness, aesthetics, originality, fairness, fun, difficulty, ROW_NUMBER() OVER (PARTITION BY id, created_at ORDER BY score DESC) as rn FROM (SELECT results.participants.agent AS id, res.created_at, map_res.score, map_res.task_rewards.composition, map_res.task_rewards.probability, map_res.task_rewards.completeness, map_res.task_rewards.aesthetics, map_res.task_rewards.originality, map_res.task_rewards.fairness, map_res.task_rewards.fun, map_res.task_rewards.difficulty FROM results CROSS JOIN UNNEST(results.results) AS t(res) CROSS JOIN UNNEST(res.history) AS h(map_res))) WHERE rn <= 10 GROUP BY id, Run_Date ORDER BY Run_Date DESC

SELECT id, Run_Date, AVG(score) AS TopK_Avg_Score, AVG(composition) AS TopK_Avg_Composition, AVG(probability) AS TopK_Avg_Probability, AVG(completeness) AS TopK_Avg_Completeness, AVG(aesthetics) AS TopK_Avg_Aesthetics, AVG(originality) AS TopK_Avg_Originality, AVG(fairness) AS TopK_Avg_Fairness, AVG(fun) AS TopK_Avg_Fun, AVG(difficulty) AS TopK_Avg_Difficulty FROM (SELECT id, created_at AS Run_Date, score, composition, probability, completeness, aesthetics, originality, fairness, fun, difficulty, ROW_NUMBER() OVER (PARTITION BY id, created_at ORDER BY score DESC) as rn FROM (SELECT results.participants.agent AS id, res.created_at, map_res.score, map_res.task_rewards.composition, map_res.task_rewards.probability, map_res.task_rewards.completeness, map_res.task_rewards.aesthetics, map_res.task_rewards.originality, map_res.task_rewards.fairness, map_res.task_rewards.fun, map_res.task_rewards.difficulty FROM results CROSS JOIN UNNEST(results.results) AS t(res) CROSS JOIN UNNEST(res.history) AS h(map_res))) WHERE rn <= 15 GROUP BY id, Run_Date ORDER BY Run_Date DESC

SELECT id, Run_Date, AVG(score) AS TopK_Avg_Score, AVG(composition) AS TopK_Avg_Composition, AVG(probability) AS TopK_Avg_Probability, AVG(completeness) AS TopK_Avg_Completeness, AVG(aesthetics) AS TopK_Avg_Aesthetics, AVG(originality) AS TopK_Avg_Originality, AVG(fairness) AS TopK_Avg_Fairness, AVG(fun) AS TopK_Avg_Fun, AVG(difficulty) AS TopK_Avg_Difficulty FROM (SELECT id, created_at AS Run_Date, score, composition, probability, completeness, aesthetics, originality, fairness, fun, difficulty, ROW_NUMBER() OVER (PARTITION BY id, created_at ORDER BY score DESC) as rn FROM (SELECT results.participants.agent AS id, res.created_at, map_res.score, map_res.task_rewards.composition, map_res.task_rewards.probability, map_res.task_rewards.completeness, map_res.task_rewards.aesthetics, map_res.task_rewards.originality, map_res.task_rewards.fairness, map_res.task_rewards.fun, map_res.task_rewards.difficulty FROM results CROSS JOIN UNNEST(results.results) AS t(res) CROSS JOIN UNNEST(res.history) AS h(map_res))) WHERE rn <= 20 GROUP BY id, Run_Date ORDER BY Run_Date DESC

SELECT id, Run_Date, AVG(score) AS TopK_Avg_Score, AVG(composition) AS TopK_Avg_Composition, AVG(probability) AS TopK_Avg_Probability, AVG(completeness) AS TopK_Avg_Completeness, AVG(aesthetics) AS TopK_Avg_Aesthetics, AVG(originality) AS TopK_Avg_Originality, AVG(fairness) AS TopK_Avg_Fairness, AVG(fun) AS TopK_Avg_Fun, AVG(difficulty) AS TopK_Avg_Difficulty FROM (SELECT id, created_at AS Run_Date, score, composition, probability, completeness, aesthetics, originality, fairness, fun, difficulty, ROW_NUMBER() OVER (PARTITION BY id, created_at ORDER BY score DESC) as rn FROM (SELECT results.participants.agent AS id, res.created_at, map_res.score, map_res.task_rewards.composition, map_res.task_rewards.probability, map_res.task_rewards.completeness, map_res.task_rewards.aesthetics, map_res.task_rewards.originality, map_res.task_rewards.fairness, map_res.task_rewards.fun, map_res.task_rewards.difficulty FROM results CROSS JOIN UNNEST(results.results) AS t(res) CROSS JOIN UNNEST(res.history) AS h(map_res))) WHERE rn <= 25 GROUP BY id, Run_Date ORDER BY Run_Date DESC

SELECT id, Avg_Score AS TopK_Avg_Score, StdDev_Score AS Score_StdDev, Avg_Composition, Avg_Probability, Avg_Completeness, Avg_Aesthetics, Avg_Originality, Avg_Fairness, Avg_Fun, Avg_Difficulty FROM (SELECT id, AVG(score) AS Avg_Score, STDDEV_SAMP(score) AS StdDev_Score, AVG(composition) AS Avg_Composition, AVG(probability) AS Avg_Probability, AVG(completeness) AS Avg_Completeness, AVG(aesthetics) AS Avg_Aesthetics, AVG(originality) AS Avg_Originality, AVG(fairness) AS Avg_Fairness, AVG(fun) AS Avg_Fun, AVG(difficulty) AS Avg_Difficulty, ROW_NUMBER() OVER (PARTITION BY id ORDER BY AVG(score) DESC) as id_rank FROM (SELECT id, created_at, score, composition, probability, completeness, aesthetics, originality, fairness, fun, difficulty, ROW_NUMBER() OVER (PARTITION BY id, created_at ORDER BY score DESC) as item_rank FROM (SELECT results.participants.agent AS id, res.created_at, map_res.score, map_res.task_rewards.composition, map_res.task_rewards.probability, map_res.task_rewards.completeness, map_res.task_rewards.aesthetics, map_res.task_rewards.originality, map_res.task_rewards.fairness, map_res.task_rewards.fun, map_res.task_rewards.difficulty FROM results CROSS JOIN UNNEST(results.results) AS t(res) CROSS JOIN UNNEST(res.history) AS h(map_res))) WHERE item_rank <= 25 GROUP BY id, created_at) WHERE id_rank = 1 ORDER BY TopK_Avg_Score DESC