Where were less than 72 goals made and more than 40 assists made?
CREATE TABLE table_name_74 (venue VARCHAR, goals VARCHAR, assists VARCHAR)
SELECT venue FROM table_name_74 WHERE goals < 72 AND assists > 40
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_74 (venue VARCHAR, goals VARCHAR, assists VARCHAR) Question: Where were less than 72 goals made and more than 40 assists made? [/INST] SELECT venue FROM table_name_74 WHERE goals < 72 AND assists > 40 </s>