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(*)  =  2
[{'city': 'Abilene'}, {'city': 'Adana'}, {'city': 'Addis Ababa'}, {'city': 'Adelaide'}, {'city': 'Ajaccio'}, {'city': 'Alamogordo'}, {'city': 'Amberley'}, {'city': 'Amman'}, {'city': 'Andersen'}, {'city': 'Araracuara'}, {'city': 'Ardmore'}, {'city': 'Argyle'}, {'city': 'Arlington'}, {'city': 'Austin'}, {'city': 'Bagan'}, {'city': 'Bahrain'}, {'city': 'Baltimore'}, {'city': 'Bandar Abbas'}, {'city': 'Bangalore'}, {'city': 'Bangkok'}, {'city': 'Baracoa Playa'}, {'city': 'Barcelona'}, {'city': 'Barrow Island'}, {'city': 'Basse Terre'}, {'city': 'Bathurst'}, {'city': 'Bauru'}, {'city': 'Beaumont'}, {'city': 'Bedford'}, {'city': 'Beijing'}, {'city': 'Belem'}, {'city': 'Belfast'}, {'city': 'Belo Horizonte'}, {'city': 'Birmingham'}, {'city': 'Bloemfontein'}, {'city': 'Bloomington'}, {'city': 'Boa Vista'}, {'city': 'Bodrum'}, {'city': 'Brest'}, {'city': 'Brisbane'}, {'city': 'Bristol'}, {'city': 'Bucharest'}, {'city': 'Budapest'}, {'city': 'Calgary'}, {'city': 'Camden'}, {'city': 'Campinas'}, {'city': 'Carlsbad'}, {'city': 'Celle'}, {'city': 'Chambery'}, {'city': 'Cincinnati'}, {'city': 'Clarksville'}, {'city': 'Clinton'}, {'city': 'Clovis'}, {'city': 'Cochrane'}, {'city': 'Cockburn Town'}, {'city': 'Cold Bay'}, {'city': 'Colmar'}, {'city': 'Colombo'}, {'city': 'Concord'}, {'city': 'Concordia'}, {'city': 'Copenhagen'}, {'city': 'Cordoba'}, {'city': 'Corpus Christi'}, {'city': 'Crestview'}, {'city': 'Curitiba'}, {'city': 'Cuxhaven'}, {'city': 'Danville'}, {'city': 'Deer Lake'}, {'city': 'Del Rio'}, {'city': 'Delhi'}, {'city': 'Derby'}, {'city': 'Dhaka'}, {'city': 'Dillingham'}, {'city': 'Doha'}, {'city': 'Dubai'}, {'city': 'Dublin'}, {'city': 'Durango'}, {'city': 'Durban'}, {'city': 'Edinburgh'}, {'city': 'Edmonton'}, {'city': 'El Calafate'}, {'city': 'El Paso'}, {'city': 'Elkhart'}, {'city': 'Ely'}, {'city': 'Esfahan'}, {'city': 'Essen'}, {'city': 'Eureka'}, {'city': 'Fairbanks'}, {'city': 'Faro'}, {'city': 'Fayetteville'}, {'city': 'Fes'}, {'city': 'Flagler'}, {'city': 'Florence'}, {'city': 'Flores'}, {'city': 'Fort Lauderdale'}, {'city': 'Fort Myers'}, {'city': 'Fort Smith'}, {'city': 'Fort Worth'}, {'city': 'Freetown'}, {'city': 'Futuna Island'}, {'city': 'Gainesville'}, {'city': 'Geraldton'}, {'city': 'Gothenborg'}, {'city': 'Granada'}, {'city': 'Grand Forks'}, {'city': 'Greenwood'}, {'city': 'Guantanamo'}, {'city': 'Guapiles'}, {'city': 'Halifax'}, {'city': 'Hamadan'}, {'city': 'Hamburg'}, {'city': 'Hampton'}, {'city': 'Hanoi'}, {'city': 'Harare'}, {'city': 'Harrisburg'}, {'city': 'Hayward'}, {'city': 'Hillsboro'}, {'city': 'Hiroshima'}, {'city': 'Hobart'}, {'city': 'Hong Kong'}, {'city': 'Hyderabad'}, {'city': 'Indianapolis'}, {'city': 'Isparta'}, {'city': 'Jamestown'}, {'city': 'Jasper'}, {'city': 'Jeddah'}, {'city': 'Kabul'}, {'city': 'Kamloops'}, {'city': 'Kansas City'}, {'city': 'Katowice'}, {'city': 'Kaunas'}, {'city': 'Kavala'}, {'city': 'Kazan'}, {'city': 'Kenora'}, {'city': 'Khabarovsk'}, {'city': 'Kinshasa'}, {'city': 'Klawock'}, {'city': 'Knoxville'}, {'city': 'Kochi'}, {'city': 'Komsomolsk-on-Amur'}, {'city': 'Kostroma'}, {'city': 'Krasnoyarsk'}, {'city': 'Kuala Lumpur'}, {'city': 'Kutahya'}, {'city': 'Kuwait'}, {'city': 'Kwajalein'}, {'city': 'La Paz'}, {'city': 'La Rochelle'}, {'city': 'Lafayette'}, {'city': 'Lahore'}, {'city': 'Lancaster'}, {'city': 'Lansing'}, {'city': 'Lanzhou'}, {'city': 'Laverton'}, {'city': 'Lawrence'}, {'city': 'Leeds'}, {'city': 'Leesburg'}, {'city': 'Leon'}, {'city': 'Lewiston'}, {'city': 'Lima'}, {'city': 'Lincoln'}, {'city': 'Linden'}, {'city': 'Linkoeping'}, {'city': 'Liverpool'}, {'city': 'Lompoc'}, {'city': 'Longview'}, {'city': 'Louisville'}, {'city': 'Lusaka'}, {'city': 'Lyon'}, {'city': 'Madison'}, {'city': 'Magadan'}, {'city': 'Makale'}, {'city': 'Malatya'}, {'city': 'Manaus'}, {'city': 'Manchester'}, {'city': 'Manzanillo'}, {'city': 'Maracaibo'}, {'city': 'Marathon'}, {'city': 'Marshall'}, {'city': 'Marshfield'}, {'city': 'Marysville'}, {'city': 'Maseru'}, {'city': 'Matsu Islands'}, {'city': 'Medan'}, {'city': 'Memphis'}, {'city': 'Merced'}, {'city': 'Merida'}, {'city': 'Mesa'}, {'city': 'Metz'}, {'city': 'Middelburg'}, {'city': 'Midland'}, {'city': 'Milano'}, {'city': 'Milwaukee'}, {'city': 'Minot'}, {'city': 'Minsk'}, {'city': 'Molokai'}, {'city': 'Monroe'}, {'city': 'Monrovia'}, {'city': 'Monterrey'}, {'city': 'Montevideo'}, {'city': 'Montgomery'}, {'city': 'Moroni'}, {'city': 'Morristown'}, {'city': 'Mount Pleasant'}, {'city': 'Mountain Home'}, {'city': 'Murcia'}, {'city': 'Murmansk'}, {'city': 'Nagoya'}, {'city': 'Nakhon Ratchasima'}, {'city': 'Nakhon Sawan'}, {'city': 'Nakhon Si Thammarat'}, {'city': 'Nanaimo'}, {'city': 'Nancy'}, {'city': 'Naples'}, {'city': 'Nassau'}, {'city': 'Naypyidaw'}, {'city': 'Nicoya'}, {'city': 'Nogales'}, {'city': 'Norfolk'}, {'city': 'Norrkoeping'}, {'city': 'Noumea'}, {'city': 'Ocana'}, {'city': 'Ogden'}, {'city': 'Olathe'}, {'city': 'Omaha'}, {'city': 'Omsk'}, {'city': 'Ontario'}, {'city': 'Orange'}, {'city': 'Oranjestad'}, {'city': 'Oriximina'}, {'city': 'Orlando'}, {'city': 'Orleans'}, {'city': 'Oslo'}, {'city': 'Padang'}, {'city': 'Palermo'}, {'city': 'Pemba'}, {'city': 'Pensacola'}, {'city': 'Perry'}, {'city': 'Peru'}, {'city': 'Peterborough'}, {'city': 'Petersburg'}, {'city': 'Petrozavodsk'}, {'city': 'Phetchabun'}, {'city': 'Pingtung'}, {'city': 'Pittsburgh'}, {'city': 'Plymouth'}, {'city': 'Port Angeles'}, {'city': 'Porto Alegre'}, {'city': 'Poznan'}, {'city': 'Princeton'}, {'city': 'Rapid City'}, {'city': 'Reims'}, {'city': 'Rhodos'}, {'city': 'Riyadh'}, {'city': 'Roi Et'}, {'city': 'Romblon'}, {'city': 'Rota'}, {'city': 'Salem'}, {'city': 'Salinas'}, {'city': 'Salt Lake City'}, {'city': 'Samana'}, {'city': 'Samara'}, {'city': 'San Fernando'}, {'city': 'San Juan'}, {'city': 'San Julian'}, {'city': 'San Salvador'}, {'city': 'San Sebastian'}, {'city': 'Sanliurfa'}, {'city': 'Santa Clara'}, {'city': 'Santa Fe'}, {'city': 'Santa Lucia'}, {'city': 'Santa Maria'}, {'city': 'Sapporo'}, {'city': 'Scranton'}, {'city': 'Seattle'}, {'city': 'Seoul'}, {'city': 'Severomorsk'}, {'city': 'Shanghai'}, {'city': 'Shenyang'}, {'city': 'Sidney'}, {'city': 'Sihanoukville'}, {'city': 'Sinop'}, {'city': 'Sovetskaya Gavan'}, {'city': 'St. Louis'}, {'city': 'St.-pierre'}, {'city': 'Stephenville'}, {'city': 'Szczecin'}, {'city': 'Tacoma'}, {'city': 'Taichung'}, {'city': 'Taipei'}, {'city': 'Tashkent'}, {'city': 'Tel-aviv'}, {'city': 'Tenerife'}, {'city': 'Tok'}, {'city': 'Toledo'}, {'city': 'Tonopah'}, {'city': 'Toowoomba'}, {'city': 'Topeka'}, {'city': 'Trenton'}, {'city': 'Treviso'}, {'city': 'Trinidad'}, {'city': 'Tripoli'}, {'city': 'Trujillo'}, {'city': 'Tulsa'}, {'city': 'Tuxtla Gutierrez'}, {'city': 'Ufa'}, {'city': 'Ulyanovsk'}, {'city': 'Uummannaq'}, {'city': 'Uvalde'}, {'city': 'Valdosta'}, {'city': 'Valencia'}, {'city': 'Verdun'}, {'city': 'Vitoria'}, {'city': 'Waco'}, {'city': 'Waterloo'}, {'city': 'Watertown'}, {'city': 'Wellington'}, {'city': 'West Palm Beach'}, {'city': 'Windhoek'}, {'city': 'Winnipeg'}, {'city': 'Yakutsk'}, {'city': 'Yaounde'}, {'city': 'Yekaterinburg'}, {'city': 'Yerevan'}, {'city': 'Zhytomyr'}]