按脚本编写SQL却遇COUNT函数报错，查询无法执行求解析

你的SQL查询报错的核心原因是语法错误：在SELECT子句中，CONCAT(start_station_name, " to ",end_station_name) AS route这一行的末尾缺少了逗号，导致SQL解析器无法正确区分后续的COUNT(*) as num_trips字段，进而引发相关报错。

修正后的完整代码 #

SELECT 
  usertype,
  CONCAT(start_station_name, " to ",end_station_name) AS route,
  COUNT(*) as num_trips, 
  ROUND(AVG(cast(tripduration as int64)/60),2) AS duration
 FROM 
    `bigquery-public-data.new_york_citibike.citibike_trips` 
  GROUP BY 
  start_station_name, end_station_name, usertype
ORDER BY
  num_trips DESC
LIMIT 10 

添加AS route后的逗号后，SQL解析器就能正确识别每个字段，COUNT(*)函数可正常执行，用于统计每个分组下的出行次数。

内容的提问来源于stack exchange，提问作者Marshlyn Walters