SELECT name ,  city ,  country ,  elevation FROM airports WHERE city  =  'New York'
Find the name, city, country, and altitude (or elevation) of the airports in the city of New York.
SELECT name , city , country , elevation FROM airports WHERE city = 'New York '
select name , city , country , elevation from airports where city = value
Find the name , city , country , and altitude ( or elevation ) of the airports in the city of New York .