What was the highest order amount in weeks prier to 15 and a major less than 1?
CREATE TABLE table_name_55 (order INTEGER, weeks VARCHAR, majors VARCHAR)
SELECT MAX(order) FROM table_name_55 WHERE weeks < 15 AND majors < 1
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_55 (order INTEGER, weeks VARCHAR, majors VARCHAR) Question: What was the highest order amount in weeks prier to 15 and a major less than 1? [/INST] SELECT MAX(order) FROM table_name_55 WHERE weeks < 15 AND majors < 1 </s>