Find the name, city, country, and altitude (or elevation) of the airports in the city of New York.
CREATE TABLE airports (name VARCHAR, city VARCHAR, country VARCHAR, elevation VARCHAR)
[SQL] SELECT name, city, country, elevation FROM airports WHERE city = 'New York' [/SQL]