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