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