SELECT tb2.name   
FROM(
    SELECT tb1.season, tb1.name, ROW_NUMBER() OVER(ORDER BY SUBSTR(tb1.season, 2, 4) ) AS number  --增加序号
    FROM(
        SELECT a.season, a.name, a.scores  --赛季，得分王，得分
        FROM (
            SELECT season, max(scores) scores
            FROM player
            GROUP BY season
        )
        b JOIN player a ON a.season = b.season AND a.scores = b.scores
    )tb1
)tb2, tb2 tb3
WHERE tb2.season=tb3.season AND tb2.name=tb3.name AND tb2.number=tb3.number-1;


这个会报错FAILED: SemanticException [Error 10001]: Line 13:6 Table not found 'tb2'