Database: flight_4
Question: What is the name, city, country, and elevation for every airport in the city of New York?
SQL:
SELECT name ,  city ,  country ,  elevation FROM airports WHERE city  =  'New York'