Select heros.Nom,heros.Prenom
From (
    SELECT  ID_Heros, 
            COUNT(ID_ville) AS nmbr,
            (
                SELECT * 
                FROM etape 
                RIGHT JOIN participe ON etape.ID_Expedition= pqrticipe.ID_Expedition
            ) as sub1 
    GROUP BY ID_Heros 
    ORDER BY COUNT(ID_ville) LIMIT 1
) As sub2 
INNER JOIN heros On sub2.ID_Heros = heros.ID_Héros

问题：查询用于：最游历的英雄（穿越的城市最多）

1064-“group by id\u heros order by count（city\u id）limit 1）as sub2”附近的语法错误

INNER JOIN hero 'at line 5

为什么我会有这个错误(我怎样才能修好它（也许）
我想是关于2点，但我不确定