How do I fix this error in Big Query?: Syntax error: Expected end of input but got "(" at [3:11]
I can't seem to find a solution to the following error. I have tried using " ", and ' ' around start_station_name to no avail. I have moved the () around as well. I can't seem to find a solution to the error. No matter what I do, I keep receiving the same syntax error message: "Syntax error: Expected end of input but got "(" at [3:11]"
Any help would be appreciated!
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_trips`
GROUP BY
start_station_name, end_station_name, usertype
ORDER BY
num_trips DESC
LIMIT 10