Which Position has 47 Goals Against, and a Played larger than 34?
CREATE TABLE table_name_2 (position INTEGER, goals_against VARCHAR, played VARCHAR)
SELECT MAX(position) FROM table_name_2 WHERE goals_against = 47 AND played > 34
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_2 (position INTEGER, goals_against VARCHAR, played VARCHAR) Question: Which Position has 47 Goals Against, and a Played larger than 34? [/INST] SELECT MAX(position) FROM table_name_2 WHERE goals_against = 47 AND played > 34 </s>