Database: bike_1
Question: What is the mean longitude for all stations that have never had more than 10 bikes available?
SQL:
SELECT avg(long) FROM station WHERE id NOT IN (SELECT station_id FROM status GROUP BY station_id HAVING max(bikes_available)  >  10)