本sql 可以在mysql 8.0 和谷歌的bigquery 中运行
WITH Roster AS
 (SELECT 'Adams' as LastName, 50 as SchoolID UNION ALL
  SELECT 'Buchanan', 52 UNION ALL
  SELECT 'Coolidge', 52 UNION ALL
  SELECT 'Davis', 51 UNION ALL
  SELECT 'Eisenhower', 77)

select * from Roster where SchoolID between 50  and 55 order by SchoolID;

LastName

SchoolID

Adams

50

Davis

51

Buchanan

52

Coolidge

52