Which station ids ever had bike availability more than 10?
select distinct station_id from status group by station_id having max(bikes_available) > 10
Which did not?
select id from station where id not in (select station_id from status group by station_id having max(bikes_available) > 10)
For those, take the average longitude.
select avg(long) from station where id not in (select station_id from status group by station_id having max(bikes_available) > 10)