What is the average latitude of stations located in San Jose city?
select avg ( lat ) from station where city = "San Jose"
What is the average longitude of stations located in San Jose city?
select avg ( long ) from station where city = "San Jose"
What are the installation dates for all stations in San Jose city?
select installation_date from station where city = "San Jose"
What are the names of each of those?
select name,installation_date from station where city = "San Jose"
What are the dock counts of each of those?
select name,dock_count from station where city = "San Jose"