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)
SELECT name, city, country, elevation FROM airports WHERE city = 'New York'
<s>[INST] Write mssql query to answer the following question given the database schema. 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. [/INST] SELECT name, city, country, elevation FROM airports WHERE city = 'New York' </s>