SELECT COUNT(*) FROM station WHERE city  =  "Mountain View"
How many stations are in Mountain View?
SELECT COUNT ( * ) FROM station WHERE city = `` Mountain View ''
select count ( * ) from station where city = value
How many stations are in Mountain View ?