SELECT r.participants.agent AS id, ROUND(res.summary.pass_rate * 100, 1) AS 'Entropic Pass Rate %', ROUND(res.summary.avg_score, 1) AS 'Entropic Score', res.summary.total_tasks AS 'No. Of Tasks', res.summary.total_passed AS 'Passed', res.timestamp AS 'Run Time' FROM results r CROSS JOIN UNNEST(r.results) AS t(res) ORDER BY res.summary.total_tasks DESC, res.summary.pass_rate DESC, res.summary.avg_score DESC

SELECT r.participants.agent AS id, ROUND(COALESCE(res.dimension_averages.FUNCTIONAL, 0), 1) AS 'Functional', ROUND(COALESCE(res.dimension_averages.DRIFT_ADAPTATION, 0), 1) AS 'Drift Adapt', ROUND(COALESCE(res.dimension_averages.TOKEN_EFFICIENCY, 0), 1) AS 'Token Eff', ROUND(COALESCE(res.dimension_averages.QUERY_EFFICIENCY, 0), 1) AS 'Query Eff', ROUND(COALESCE(res.dimension_averages.ERROR_RECOVERY, 0), 1) AS 'Error Rec', ROUND(COALESCE(res.dimension_averages.TRAJECTORY_EFFICIENCY, 0), 1) AS 'Trajectory Eff', ROUND(COALESCE(res.dimension_averages.HALLUCINATION_RATE, 0), 1) AS 'No Hallucination', res.summary.total_tasks AS 'No. Of Tasks', res.timestamp AS 'Run Time' FROM results r CROSS JOIN UNNEST(r.results) AS t(res) ORDER BY res.dimension_averages.FUNCTIONAL DESC

SELECT r.participants.agent AS id, ROUND(CAST(COALESCE(res.original.scores.accuracy_percent, 0) AS DOUBLE), 1) AS 'Original Pass %', CAST(COALESCE(res.original.summary.passed, 0) AS INTEGER) AS 'Passed', CAST(COALESCE(res.original.summary.failed, 0) AS INTEGER) AS 'Failed', CAST(COALESCE(res.original.summary.total_tasks, res.summary.total_tasks) AS INTEGER) AS 'No. Of Tasks', res.timestamp AS 'Run Time' FROM results r CROSS JOIN UNNEST(r.results) AS t(res) ORDER BY CAST(res.original.scores.accuracy_percent AS DOUBLE) DESC NULLS LAST

SELECT r.participants.agent AS id, ROUND(res.summary.pass_rate * 100, 1) AS 'Entropic Pass Rate %', ROUND(res.summary.avg_score, 1) AS 'Entropic Score', ROUND(CAST(COALESCE(res.original.scores.accuracy_percent, 0) AS DOUBLE), 1) AS 'Original Pass %', res.summary.total_tasks AS 'No. Of Tasks', res.timestamp AS 'Run Time' FROM results r CROSS JOIN UNNEST(r.results) AS t(res) ORDER BY res.timestamp DESC