无法解决错误消息" Expected "(" but got identifier " Bigquery 中的行程持续时间" at [4:16]"

Question

这是我的代码：

SELECT usertype,
CONCAT(start_station_name,"to",end_station_name),
COUNT(*) AS num_trips,
ROUND(AVG(CAST tripduration AS int64/60,2)) AS Newduration
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

Answer 1

试试这个

您错过了CAST附近的((

SELECT usertype,
CONCAT(start_station_name,"to",end_station_name),
COUNT(*) AS num_trips,
ROUND(AVG(CAST (tripduration AS int64)/60),2) AS Newduration
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