Google BigQuery SQL错误-无法访问[5:47]处类型为FLOAT64的值的字段2

Question

真的需要一些帮助。我仔细检查了我的代码，确保我有正确的标点符号，并按照我正在学习的课程中显示的内容做了所有事情。仍收到错误。这是代码：

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

ERROR无法访问[5:47]上类型为FLOAT64的值的字段2

Answer 1

round函数使用逗号而不是点。你应该把2前面的点改成逗号。