SELECT t.participants.agent AS id,r.result.total_score AS score,r.result.total_max_score AS max_score,r.result.avg_action_control AS action_control,r.result.avg_error_recognition_and_correction AS   error_recognition_and_correction,r.result.avg_creative_attempts AS creative_attempts,r.result.avg_task_completion_efficiency AS task_completion_efficiency,r.result.avg_material_selection_and_usage AS material_selection_and_usage FROM results t CROSS JOIN   UNNEST(t.results) AS r(result) WHERE r.result.task_category='building' ORDER BY score DESC,id;

SELECT t.participants.agent AS id,r.result.total_score AS score,r.result.total_max_score AS max_score,r.result.avg_action_control AS action_control,r.result.avg_error_recognition_and_correction AS   error_recognition_and_correction,r.result.avg_creative_attempts AS creative_attempts,r.result.avg_task_completion_efficiency AS task_completion_efficiency,r.result.avg_material_selection_and_usage AS material_selection_and_usage FROM results t CROSS JOIN   UNNEST(t.results) AS r(result) WHERE r.result.task_category='combat' ORDER BY score DESC,id;

SELECT t.participants.agent AS id,r.result.total_score AS score,r.result.total_max_score AS max_score,r.result.avg_action_control AS action_control,r.result.avg_error_recognition_and_correction AS   error_recognition_and_correction,r.result.avg_creative_attempts AS creative_attempts,r.result.avg_task_completion_efficiency AS task_completion_efficiency,r.result.avg_material_selection_and_usage AS material_selection_and_usage FROM results t CROSS JOIN   UNNEST(t.results) AS r(result) WHERE r.result.task_category='crafting' ORDER BY score DESC,id;

SELECT t.participants.agent AS id,r.result.total_score AS score,r.result.total_max_score AS max_score,r.result.avg_action_control AS action_control,r.result.avg_error_recognition_and_correction AS   error_recognition_and_correction,r.result.avg_creative_attempts AS creative_attempts,r.result.avg_task_completion_efficiency AS task_completion_efficiency,r.result.avg_material_selection_and_usage AS material_selection_and_usage FROM results t CROSS JOIN   UNNEST(t.results) AS r(result) WHERE r.result.task_category='decoration' ORDER BY score DESC,id;

SELECT t.participants.agent AS id,r.result.total_score AS score,r.result.total_max_score AS max_score,r.result.avg_action_control AS action_control,r.result.avg_error_recognition_and_correction AS   error_recognition_and_correction,r.result.avg_creative_attempts AS creative_attempts,r.result.avg_task_completion_efficiency AS task_completion_efficiency,r.result.avg_material_selection_and_usage AS material_selection_and_usage FROM results t CROSS JOIN   UNNEST(t.results) AS r(result) WHERE r.result.task_category='explore' ORDER BY score DESC,id;

SELECT t.participants.agent AS id,r.result.total_score AS score,r.result.total_max_score AS max_score,r.result.avg_action_control AS action_control,r.result.avg_error_recognition_and_correction AS   error_recognition_and_correction,r.result.avg_creative_attempts AS creative_attempts,r.result.avg_task_completion_efficiency AS task_completion_efficiency,r.result.avg_material_selection_and_usage AS material_selection_and_usage FROM results t CROSS JOIN   UNNEST(t.results) AS r(result) WHERE r.result.task_category='find' ORDER BY score DESC,id;

SELECT t.participants.agent AS id,r.result.total_score AS score,r.result.total_max_score AS max_score,r.result.avg_action_control AS action_control,r.result.avg_error_recognition_and_correction AS   error_recognition_and_correction,r.result.avg_creative_attempts AS creative_attempts,r.result.avg_task_completion_efficiency AS task_completion_efficiency,r.result.avg_material_selection_and_usage AS material_selection_and_usage FROM results t CROSS JOIN   UNNEST(t.results) AS r(result) WHERE r.result.task_category='mining_and_collecting' ORDER BY score DESC,id;

SELECT t.participants.agent AS id,r.result.total_score AS score,r.result.total_max_score AS max_score,r.result.avg_action_control AS action_control,r.result.avg_error_recognition_and_correction AS   error_recognition_and_correction,r.result.avg_creative_attempts AS creative_attempts,r.result.avg_task_completion_efficiency AS task_completion_efficiency,r.result.avg_material_selection_and_usage AS material_selection_and_usage FROM results t CROSS JOIN   UNNEST(t.results) AS r(result) WHERE r.result.task_category='motion' ORDER BY score DESC,id;

SELECT t.participants.agent AS id,r.result.total_score AS score,r.result.total_max_score AS max_score,r.result.avg_action_control AS action_control,r.result.avg_error_recognition_and_correction AS   error_recognition_and_correction,r.result.avg_creative_attempts AS creative_attempts,r.result.avg_task_completion_efficiency AS task_completion_efficiency,r.result.avg_material_selection_and_usage AS material_selection_and_usage FROM results t CROSS JOIN   UNNEST(t.results) AS r(result) WHERE r.result.task_category='tool_use' ORDER BY score DESC,id;

SELECT t.participants.agent AS id,r.result.total_score AS score,r.result.total_max_score AS max_score,r.result.avg_action_control AS action_control,r.result.avg_error_recognition_and_correction AS   error_recognition_and_correction,r.result.avg_creative_attempts AS creative_attempts,r.result.avg_task_completion_efficiency AS task_completion_efficiency,r.result.avg_material_selection_and_usage AS material_selection_and_usage FROM results t CROSS JOIN   UNNEST(t.results) AS r(result) WHERE r.result.task_category='mine_diamond_from_scratch' ORDER BY score DESC,id;

SELECT t.participants.agent AS id,r.result.total_score AS score,r.result.total_max_score AS max_score,r.result.avg_action_control AS action_control,r.result.avg_error_recognition_and_correction AS   error_recognition_and_correction,r.result.avg_creative_attempts AS creative_attempts,r.result.avg_task_completion_efficiency AS task_completion_efficiency,r.result.avg_material_selection_and_usage AS material_selection_and_usage FROM results t CROSS JOIN   UNNEST(t.results) AS r(result) WHERE r.result.task_category='ender_dragon' ORDER BY score DESC,id;

SELECT t.participants.agent AS id,r.result.total_score AS score,r.result.total_max_score AS max_score,r.result.avg_action_control AS action_control,r.result.avg_error_recognition_and_correction AS   error_recognition_and_correction,r.result.avg_creative_attempts AS creative_attempts,r.result.avg_task_completion_efficiency AS task_completion_efficiency,r.result.avg_material_selection_and_usage AS material_selection_and_usage FROM results t CROSS JOIN   UNNEST(t.results) AS r(result) WHERE r.result.task_category='trapping' ORDER BY score DESC,id;