SELECT id, ROUND(MAX(COALESCE(result.correct_tasks::DOUBLE / NULLIF(result.total_tasks, 0), result.average_score)) * 100, 1) AS 'Pass Rate', NULL AS 'Time', MAX(result.total_tasks) AS '# Tasks' FROM results WHERE status = 'completed' GROUP BY id ORDER BY 'Pass Rate' DESC;