SELECT participants.purple_agent AS id, ROUND(r.overall_score.score, 1) AS "Score", r.evaluation_metadata.num_tasks AS "Tasks", r.evaluation_metadata.num_successful AS "Passed" FROM (SELECT participants, results[1] AS r FROM results) ORDER BY r.overall_score.score DESC

SELECT participants.purple_agent AS id, ROUND(r.section_scores.knowledge_retrieval.score, 1) AS "Knowledge", ROUND(r.section_scores.analytical_reasoning.score, 1) AS "Analysis", ROUND(r.section_scores.options_trading.score, 1) AS "Options", ROUND(r.section_scores.crypto_trading.score, 1) AS "Crypto", ROUND(r.section_scores.professional_tasks.score, 1) AS "GDPVal" FROM (SELECT participants, results[1] AS r FROM results) ORDER BY r.overall_score.score DESC

SELECT participants.purple_agent AS id, ROUND(r.section_scores.professional_tasks.score, 1) AS "Score", ROUND(r.section_scores.professional_tasks.sub_scores.completion, 1) AS "Completion", ROUND(r.section_scores.professional_tasks.sub_scores.accuracy, 1) AS "Accuracy", ROUND(r.section_scores.professional_tasks.sub_scores.format, 1) AS "Format", ROUND(r.section_scores.professional_tasks.sub_scores.professionalism, 1) AS "Prof." FROM (SELECT participants, results[1] AS r FROM results) WHERE r.section_scores.professional_tasks IS NOT NULL ORDER BY r.section_scores.professional_tasks.score DESC

SELECT participants.purple_agent AS id, ROUND(r.section_scores.crypto_trading.score, 1) AS "Score", ROUND(r.section_scores.crypto_trading.sub_scores.baseline, 1) AS "Baseline", ROUND(r.section_scores.crypto_trading.sub_scores.noisy, 1) AS "Noisy", ROUND(r.section_scores.crypto_trading.sub_scores.adversarial, 1) AS "Adversarial", ROUND(r.section_scores.crypto_trading.sub_scores.meta, 1) AS "Meta" FROM (SELECT participants, results[1] AS r FROM results) WHERE r.section_scores.crypto_trading IS NOT NULL ORDER BY r.section_scores.crypto_trading.score DESC