SELECT city FROM airports GROUP BY city HAVING count(*)  =  2
What are the cities with exactly two airports?
SELECT city FROM airports GROUP BY city HAVING count ( * ) = 2
select city from airports group by city having count ( * ) = value
What are the cities with exactly two airports ?