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

What is the average longitude of stations that never had bike availability more than 10?
SELECT AVG(long) FROM station WHERE NOT id IN (SELECT station_id FROM status GROUP BY station_id HAVING MAX(bikes_available) > 10)
SELECT AVG("long") FROM "station" WHERE NOT "id" IN (SELECT "station_id" FROM "status" GROUP BY "station_id" HAVING MAX("bikes_available") > 10)