CREATE TABLE status (id VARCHAR2, station_id VARCHAR2, city VARCHAR2, bikes_available NUMBER)
CREATE TABLE station (id VARCHAR2, station_id VARCHAR2, city VARCHAR2, bikes_available NUMBER)

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
SELECT "id" FROM "station" WHERE "San Francisco" = "city" INTERSECT SELECT "station_id" FROM "status" GROUP BY "station_id" HAVING AVG("bikes_available") > 10