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