SELECT json_extract_string(to_json(participants), '$.' || list_extract(json_keys(to_json(participants)), 1)) AS id, ROUND(COALESCE(res.partial_results.success_rate, json_extract(to_json(res), '$.success_rate')::DOUBLE, 0) * 100, 1) AS "Pass Rate", COALESCE(res.partial_results.total_tasks, json_extract(to_json(res), '$.total_tasks')::INTEGER, 0) AS "# Tasks", COALESCE(res.partial_results.passed_tasks, json_extract(to_json(res), '$.passed_tasks')::INTEGER, 0) AS "Passed", COALESCE(res.partial_results.failed_tasks, json_extract(to_json(res), '$.failed_tasks')::INTEGER, 0) AS "Failed", COALESCE(res.partial_results.completed_tasks, json_extract(to_json(res), '$.completed_tasks')::INTEGER, 0) AS "Completed" FROM results CROSS JOIN UNNEST(results) AS r(res) ORDER BY "Pass Rate" DESC;