How many stations have an average bike availability above 10?
select count ( * ) from ( select * from station as t1 join status as t2 on t1.id = t2.station_id group by t2.station_id having avg ( bikes_available ) > 10 )
How many of those are not in San Jose City?
select count ( * ) from ( select t1.name from station as t1 join status as t2 on t1.id = t2.station_id group by t2.station_id having avg ( bikes_available ) > 10 except select name from station where city = "San Jose" )
What are the names of those stations?
select t1.name from station as t1 join status as t2 on t1.id = t2.station_id group by t2.station_id having avg ( bikes_available ) > 10 except select name from station where city = "San Jose"