CREATE TABLE station (long INT, id VARCHAR, station_id VARCHAR, bikes_available INT)
CREATE TABLE status (long INT, id VARCHAR, station_id VARCHAR, bikes_available INT)

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)