Who has a highest Long with 26 Yards and less than 9 Car?
CREATE TABLE table_name_84 (long INTEGER, yards VARCHAR, car VARCHAR)
SELECT MAX(long) FROM table_name_84 WHERE yards = "26" AND car < 9
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_84 (long INTEGER, yards VARCHAR, car VARCHAR) Question: Who has a highest Long with 26 Yards and less than 9 Car? [/INST] SELECT MAX(long) FROM table_name_84 WHERE yards = "26" AND car < 9 </s>