What position did Max Redfield play?
CREATE TABLE table_name_97 (position VARCHAR, player VARCHAR)
SELECT position FROM table_name_97 WHERE player = "max redfield"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_97 (position VARCHAR, player VARCHAR) Question: What position did Max Redfield play? [/INST] SELECT position FROM table_name_97 WHERE player = "max redfield" </s>