Database: flight_4
Question: Find the name, city, country, and altitude (or elevation) of the airports in the city of New York.
SQL:
SELECT name ,  city ,  country ,  elevation FROM airports WHERE city  =  'New York'