Database: bike_1
Question: What is the average longitude of stations that never had bike availability more than 10?
SQL:
SELECT avg(long) FROM station WHERE id NOT IN (SELECT station_id FROM status GROUP BY station_id HAVING max(bikes_available)  >  10)