SELECT city FROM airports GROUP BY city HAVING count(*)  =  2
Find the cities which have exactly two airports.
SELECT city FROM airports GROUP BY city HAVING count ( * ) = 2
select city from airports group by city having count ( * ) = value
Find the cities which have exactly two airports .