What is the highest Average, when Goals is "34", and when Matches is less than 37?
CREATE TABLE table_name_41 (average INTEGER, goals VARCHAR, matches VARCHAR)
SELECT MAX(average) FROM table_name_41 WHERE goals = 34 AND matches < 37
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_41 (average INTEGER, goals VARCHAR, matches VARCHAR) Question: What is the highest Average, when Goals is "34", and when Matches is less than 37? [/INST] SELECT MAX(average) FROM table_name_41 WHERE goals = 34 AND matches < 37 </s>