Which Year has an Album of airwaves, and a US Hot 100 of –?
CREATE TABLE table_name_64 (year INTEGER, album VARCHAR, us_hot_100 VARCHAR)
SELECT MAX(year) FROM table_name_64 WHERE album = "airwaves" AND us_hot_100 = "–"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_64 (year INTEGER, album VARCHAR, us_hot_100 VARCHAR) Question: Which Year has an Album of airwaves, and a US Hot 100 of –? [/INST] SELECT MAX(year) FROM table_name_64 WHERE album = "airwaves" AND us_hot_100 = "–" </s>