Which name has an Order smaller than 997,more than 5 goals, and 215 games?
CREATE TABLE table_name_43 (name VARCHAR, games VARCHAR, order VARCHAR, goals VARCHAR)
SELECT name FROM table_name_43 WHERE order < 997 AND goals > 5 AND games = 215
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_43 (name VARCHAR, games VARCHAR, order VARCHAR, goals VARCHAR) Question: Which name has an Order smaller than 997,more than 5 goals, and 215 games? [/INST] SELECT name FROM table_name_43 WHERE order < 997 AND goals > 5 AND games = 215 </s>