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'