When total goals is 11 what was the league apps (sub)?
CREATE TABLE table_1112176_1 (league_apps__sub_ INTEGER, total_goals VARCHAR)
SELECT MAX(league_apps__sub_) FROM table_1112176_1 WHERE total_goals = 11
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_1112176_1 (league_apps__sub_ INTEGER, total_goals VARCHAR) Question: When total goals is 11 what was the league apps (sub)? [/INST] SELECT MAX(league_apps__sub_) FROM table_1112176_1 WHERE total_goals = 11 </s>