SELECT avg(long) FROM station WHERE id NOT IN (SELECT station_id FROM status GROUP BY station_id HAVING max(bikes_available)  >  10)
What is the average longitude of stations that never had bike availability more than 10?
SELECT avg ( long ) FROM station WHERE id NOT IN ( SELECT station_id FROM status GROUP BY station_id HAVING max ( bikes_available ) > 10 )
select avg ( long ) from station where id not in ( select station_id from status group by station_id having max ( bikes_available ) > value )
What is the average longitude of stations that never had bike availability more than 10 ?