What are the ids of the stations in San Francisco that normally have more than 10 bikes available?
SELECT id FROM station WHERE city  =  "San Francisco" INTERSECT SELECT station_id FROM status GROUP BY station_id HAVING avg(bikes_available)  >  10
stations in San Francisco refers to city = 'San Francisco'; normally have more than 10 bikes available refers to HAVING AVG(bikes_available) > 10;