Database: bike_1
Question: For each start station id, what is its name, longitude and average duration of trips started there?
SQL:
SELECT T1.name ,  T1.long ,  avg(T2.duration) FROM station AS T1 JOIN trip AS T2 ON T1.id  =  T2.start_station_id GROUP BY T2.start_station_id