SELECT AVG(long) FROM station WHERE NOT id 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?
CREATE TABLE status (
    station_id number,
    bikes_available number,
    docks_available number,
    time text
)

CREATE TABLE station (
    id number,
    name text,
    lat number,
    long number,
    dock_count number,
    city text,
    installation_date text
)

CREATE TABLE weather (
    date text,
    max_temperature_f number,
    mean_temperature_f number,
    min_temperature_f number,
    max_dew_point_f number,
    mean_dew_point_f number,
    min_dew_point_f number,
    max_humidity number,
    mean_humidity number,
    min_humidity number,
    max_sea_level_pressure_inches number,
    mean_sea_level_pressure_inches number,
    min_sea_level_pressure_inches number,
    max_visibility_miles number,
    mean_visibility_miles number,
    min_visibility_miles number,
    max_wind_speed_mph number,
    mean_wind_speed_mph number,
    max_gust_speed_mph number,
    precipitation_inches number,
    cloud_cover number,
    events text,
    wind_dir_degrees number,
    zip_code number
)

CREATE TABLE trip (
    id number,
    duration number,
    start_date text,
    start_station_name text,
    start_station_id number,
    end_date text,
    end_station_name text,
    end_station_id number,
    bike_id number,
    subscription_type text,
    zip_code number
)