CREATE TABLE airports (name VARCHAR(255), city VARCHAR(255), country VARCHAR(255), elevation VARCHAR(255))
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'