Hi, can you tell me how many trips there have been, starting from
 August?
select count ( * ) from trip where start_date like "8/%"
oh wow that's a lot! and how many stations have those started from?
select count ( distinct start_station_name ) from trip where start_date like "8/%"
how many trips started from there?
select count ( * ) from trip where start_station_name = ( select start_station_name from trip where start_date like "8/%" group by start_station_name order by count ( * ) desc limit 1 )
Could you tell me the ID and name of the San Francisco station?
select distinct start_station_name, start_station_id from trip where start_station_name = 'San francisco caltrain 2 ( 330 townsend ) '