Which end station names have more than 100 trips ending there?
select distinct end_station_name from trip group by end_station_name having count(*) > 100
Which station names are in city "Palo Alto"?
select name from station where city = "Palo Alto"
Take set minus on the last two results: what are the names of stations that are located in Palo Alto city but have never been the ending point of trips more than 100 times?
select name from station where city = "Palo Alto" except select end_station_name from trip group by end_station_name having count(*) > 100