What is the lowest league goals that have 0 as the FA Cup Apps, with 1 (3) as totals apps?
CREATE TABLE table_name_46 (league_goals INTEGER, fa_cup_apps VARCHAR, total_apps VARCHAR)
SELECT MIN(league_goals) FROM table_name_46 WHERE fa_cup_apps = "0" AND total_apps = "1 (3)"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_46 (league_goals INTEGER, fa_cup_apps VARCHAR, total_apps VARCHAR) Question: What is the lowest league goals that have 0 as the FA Cup Apps, with 1 (3) as totals apps? [/INST] SELECT MIN(league_goals) FROM table_name_46 WHERE fa_cup_apps = "0" AND total_apps = "1 (3)" </s>