What cities in the United States have more than 4 airports?
SELECT city FROM airports WHERE country   =   'United States' GROUP BY city HAVING count ( * )   >  4
cities in the United States refers to city WHERE country = 'United States'; more than 4 airports refers to HAVING COUNT(*) > 4;