Yes.
select id from station where city = "San Francisco"
Which of these have bikes?
select id from station where city = "San Francisco" intersect select station_id from status where bikes_available > 0
Which of these have an 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