SELECT participants.qa_agent AS id, r.participant.name AS participant_name, r.scores.micro_accuracy AS score, r.scores.micro_accuracy AS accuracy, r.scores.micro_covered_units AS covered_units, r.scores.micro_avg_agreement AS micro_avg_agreement, r.scores.micro_strict_consistency_rate AS micro_strict_consistency_rate, r.usage.tokens_total AS tokens_total, r.usage.calls AS calls FROM results CROSS JOIN UNNEST(results) AS t(r) WHERE r.scores.micro_accuracy IS NOT NULL ORDER BY score DESC

SELECT participants.qa_agent AS id, r.participant.name AS participant_name, d.dataset AS dataset, d.accuracy AS score, d.accuracy AS accuracy, d.coverage_rate AS coverage_rate, d.invalid_rate AS invalid_rate, d.ambiguous_rate AS ambiguous_rate, d.avg_agreement AS avg_agreement, d.strict_consistency_rate AS strict_consistency_rate, d.units_selected AS units_selected, d.usage.tokens_total AS tokens_total, d.usage.calls AS calls FROM results CROSS JOIN UNNEST(results) AS t(r) CROSS JOIN UNNEST(r.per_dataset) AS u(d) WHERE r.schema_version = '1.0' AND r.participant.name IS NOT NULL ORDER BY score DESC