What is the largest played number when the difference is - 8 and position is more than 8?
CREATE TABLE table_name_42 (played INTEGER, difference VARCHAR, position VARCHAR)
SELECT MAX(played) FROM table_name_42 WHERE difference = "- 8" AND position > 8
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_42 (played INTEGER, difference VARCHAR, position VARCHAR) Question: What is the largest played number when the difference is - 8 and position is more than 8? [/INST] SELECT MAX(played) FROM table_name_42 WHERE difference = "- 8" AND position > 8 </s>