Tell me the highest league goals with total goals less than 1 and FA cups more than 0
CREATE TABLE table_name_67 (league_goals INTEGER, total_goals VARCHAR, fa_cup_goals VARCHAR)
SELECT MAX(league_goals) FROM table_name_67 WHERE total_goals < 1 AND fa_cup_goals > 0
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_67 (league_goals INTEGER, total_goals VARCHAR, fa_cup_goals VARCHAR) Question: Tell me the highest league goals with total goals less than 1 and FA cups more than 0 [/INST] SELECT MAX(league_goals) FROM table_name_67 WHERE total_goals < 1 AND fa_cup_goals > 0 </s>