Which station ids have average availability above 10?
select distinct station_id from status group by station_id having avg(bikes_available) > 10
And which are located in San Francisco?
select distinct id from station where city = "San Francisco"
Which pass both conditions?
select id from station where city = "San Francisco" intersect select station_id from status group by station_id having avg(bikes_available) > 10