SELECT t.participants.participant AS id, game.efficiency_score AS Score, game.moves_used AS Moves, game.success AS Success, CAST(game.mice_rescued_percentage AS INTEGER) AS "Mice %", game.token_usage.total AS Tokens, STRFTIME(CAST(benchmark.timestamp AS TIMESTAMP), '%Y-%m-%d') AS Date FROM results AS t CROSS JOIN UNNEST(t.results) AS b(benchmark) CROSS JOIN UNNEST(benchmark.results) AS r(game) WHERE game.level_played = '1' ORDER BY Score DESC, id ASC

SELECT id, COUNT(*) AS Games, ROUND(AVG(TRY_CAST(Score AS DOUBLE)), 2) AS "Avg Score", ROUND(AVG(TRY_CAST(Moves AS DOUBLE)), 2) AS "Avg Moves", CAST(AVG(CASE WHEN CAST(Success AS VARCHAR) IN ('true', '1', 'True', 'TRUE') THEN 100.0 ELSE 0.0 END) AS INTEGER) AS "Win %", ROUND(AVG(TRY_CAST(Mice_Pct AS DOUBLE)), 2) AS "Avg Mice %", CAST(AVG(TRY_CAST(Tokens AS DOUBLE)) AS INTEGER) AS "Avg Tokens" FROM (SELECT t.participants.participant AS id, r.game.efficiency_score AS Score, r.game.moves_used AS Moves, r.game.success AS Success, r.game.mice_rescued_percentage AS Mice_Pct, r.game.token_usage.total AS Tokens FROM results t CROSS JOIN UNNEST(t.results) AS b(bench) CROSS JOIN UNNEST(b.bench.results) AS r(game) WHERE CAST(r.game.level_played AS VARCHAR) = '1') GROUP BY id ORDER BY "Avg Score" DESC