How many goals were scored on the goalkeeper with fewer than 37 matches and an average of 1.5?
CREATE TABLE table_name_24 (goals VARCHAR, matches VARCHAR, average VARCHAR)
SELECT goals FROM table_name_24 WHERE matches < 37 AND average = 1.5
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_24 (goals VARCHAR, matches VARCHAR, average VARCHAR) Question: How many goals were scored on the goalkeeper with fewer than 37 matches and an average of 1.5? [/INST] SELECT goals FROM table_name_24 WHERE matches < 37 AND average = 1.5 </s>