SELECT LOCATION FROM station GROUP BY LOCATION HAVING count(*)  =  1
Show all locations with only 1 station.
SELECT LOCATION FROM station GROUP BY LOCATION HAVING count ( * ) = 1
select location from station group by location having count ( * ) = value
Show all locations with only 1 station .