SELECT results.participants.agent AS id, ROUND(CAST(res.accuracy AS DOUBLE), 1) AS "Accuracy (%)", CAST(res.correct_count AS INTEGER) AS "✓ Correct", CAST(res.total_count AS INTEGER) AS "# Total" FROM results CROSS JOIN UNNEST(results.results) AS r(res) WHERE res.config.benchmark = 'bfcl' ORDER BY "Accuracy (%)" DESC, "# Total" DESC

SELECT agent_id AS id, kv.key AS "Category", ROUND((json_extract(kv.value, '$.success')::DOUBLE / NULLIF(json_extract(kv.value, '$.total')::DOUBLE, 0)) * 100, 1) AS "Accuracy (%)", json_extract(kv.value, '$.success')::INTEGER AS "✓", json_extract(kv.value, '$.total')::INTEGER AS "Total" FROM (SELECT results.participants.agent AS agent_id, r.res AS res FROM results CROSS JOIN UNNEST(results.results) AS r(res) WHERE r.res.config.benchmark = 'bfcl') AS base CROSS JOIN json_each(to_json(base.res.category_stats)) AS kv ORDER BY id, "Accuracy (%)" DESC

SELECT results.participants.agent AS id, ROUND(CAST(res.overall_success_rate AS DOUBLE), 1) AS "Success Rate (%)", ROUND(CAST(res.overall_call_accuracy AS DOUBLE), 1) AS "Call Acc (%)", CAST(res.successful_samples AS VARCHAR) || '/' || CAST(res.total_samples AS VARCHAR) AS "Tasks", ROUND(COALESCE(CAST(res.avg_completeness AS DOUBLE), 0), 2) AS "Completeness", ROUND(COALESCE(CAST(res.avg_correctness AS DOUBLE), 0), 2) AS "Correctness" FROM results CROSS JOIN UNNEST(results.results) AS r(res) WHERE res.config.benchmark IN ('cfb', 'complexfuncbench') ORDER BY "Success Rate (%)" DESC, "Call Acc (%)" DESC

SELECT agent_id AS id, kv.key AS "Domain", ROUND((json_extract(kv.value, '$.success')::DOUBLE / NULLIF(json_extract(kv.value, '$.total')::DOUBLE, 0)) * 100, 1) AS "Success Rate (%)", CAST(json_extract(kv.value, '$.success')::INTEGER AS VARCHAR) || '/' || CAST(json_extract(kv.value, '$.total')::INTEGER AS VARCHAR) AS "Tasks", ROUND((json_extract(kv.value, '$.correct_calls')::DOUBLE / NULLIF(json_extract(kv.value, '$.total_calls')::DOUBLE, 0)) * 100, 1) AS "Call Acc (%)" FROM (SELECT results.participants.agent AS agent_id, r.res AS res FROM results CROSS JOIN UNNEST(results.results) AS r(res) WHERE r.res.config.benchmark IN ('cfb', 'complexfuncbench')) AS base CROSS JOIN json_each(to_json(base.res.domain_stats)) AS kv ORDER BY id, "Success Rate (%)" DESC

SELECT results.participants.agent AS id, ROUND(AVG(CAST(res.pass_rate AS DOUBLE)), 1) AS "Avg Pass Rate (%)", CAST(SUM(CAST(res.score AS INTEGER)) AS VARCHAR) || '/' || CAST(SUM(CAST(res.max_score AS INTEGER)) AS VARCHAR) AS "Total Score", ROUND(SUM(CAST(res.time_used AS DOUBLE)), 1) AS "Total Time (s)" FROM results CROSS JOIN UNNEST(results.results) AS r(res) WHERE res.config.benchmark = 'tau2' GROUP BY results.participants.agent ORDER BY "Avg Pass Rate (%)" DESC, "Total Time (s)" ASC

SELECT results.participants.agent AS id, CAST(res.domain AS VARCHAR) AS "Domain", ROUND(CAST(res.pass_rate AS DOUBLE), 1) AS "Pass Rate (%)", CAST(CAST(res.score AS INTEGER) AS VARCHAR) || '/' || CAST(res.max_score AS VARCHAR) AS "Score", ROUND(CAST(res.time_used AS DOUBLE), 1) AS "Time (s)" FROM results CROSS JOIN UNNEST(results.results) AS r(res) WHERE res.config.benchmark = 'tau2' ORDER BY "Domain", "Pass Rate (%)" DESC, "Time (s)" ASC