What are the dock count of San Jose Diridon Caltrain Station?
select dock_count from station where name = "San jose diridon caltrain Station"
What are the bike id of zip code 94041?
select bike_id from trip where zip_code = 94041
Yes
select sum ( dock_count ) from station where city = "San Jose"
For each station, return its longitude and the average duration of trips that started from the station.
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 t1.name