CREATE TABLE status (id VARCHAR(255), station_id VARCHAR(255), city VARCHAR(255), bikes_available INTEGER); CREATE TABLE station (id VARCHAR(255), station_id VARCHAR(255), city VARCHAR(255), bikes_available INTEGER)
What are the ids of stations that are located in San Francisco and have average bike availability above 10.
    
SQL: SELECT id FROM station WHERE city = "San Francisco" INTERSECT SELECT station_id FROM status GROUP BY station_id HAVING AVG(bikes_available) > 10