Good morning, could you please let me know the IDs of the stations those are located in San Francisco?
select id from station where city = "San Francisco"
That's a big list, thank you. Then could you please let me know which of these stations has more than 10 bikes available?
select id from station where city = "San Francisco" intersect select station_id from status group by station_id having bikes_available > 10
That was fast, thank you again :) Could you please let me know which station is located in the highest latitude?
select name from station order by lat desc limit 1
Awesome, then could you please let me know the installation date of the station?
select installation_date from station order by lat desc limit 1
Wow that's a lot. Thank you again, this will be my last question :) Could you please let me know the ID of the station which has the biggest number of docks available among these 61 stations?
select id from station where installation_date<'8/6/2013' order by dock_count desc limit 1