What is the most total goals for a player having 0 FA Cup goals and 41 League appearances?
CREATE TABLE table_name_98 (total_goals INTEGER, fa_cup_goals VARCHAR, league_apps VARCHAR)
SELECT MAX(total_goals) FROM table_name_98 WHERE fa_cup_goals = 0 AND league_apps = "41"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_98 (total_goals INTEGER, fa_cup_goals VARCHAR, league_apps VARCHAR) Question: What is the most total goals for a player having 0 FA Cup goals and 41 League appearances? [/INST] SELECT MAX(total_goals) FROM table_name_98 WHERE fa_cup_goals = 0 AND league_apps = "41" </s>