What are the ids of stations that are located in San Francisco and have average bike availability above 10.
select id from station where city = "San Francisco" intersect select station_id from status group by station_id having avg(bikes_available) > 10