What are their names?
SELECT name FROM airports WHERE country   =   'United States' GROUP BY city HAVING count ( * )   >  4
their names refers to SELECT name; condition on being in 'United States' refers to WHERE country = 'United States'; grouping by city with more than four entries refers to GROUP BY city HAVING COUNT(*) > 4;