What is the average speed for ships before 1974 with over 1.73 passengers?
CREATE TABLE table_name_31 (speed INTEGER, year VARCHAR, passengers VARCHAR)
SELECT AVG(speed) FROM table_name_31 WHERE year < 1974 AND passengers > 1.73
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_31 (speed INTEGER, year VARCHAR, passengers VARCHAR) Question: What is the average speed for ships before 1974 with over 1.73 passengers? [/INST] SELECT AVG(speed) FROM table_name_31 WHERE year < 1974 AND passengers > 1.73 </s>