How many yards for the player with 1 solo tackle and over 0 sacks?
CREATE TABLE table_name_25 (yards INTEGER, solo VARCHAR, sack VARCHAR)
SELECT MAX(yards) FROM table_name_25 WHERE solo = 1 AND sack > 0
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_25 (yards INTEGER, solo VARCHAR, sack VARCHAR) Question: How many yards for the player with 1 solo tackle and over 0 sacks? [/INST] SELECT MAX(yards) FROM table_name_25 WHERE solo = 1 AND sack > 0 </s>