What's the most league cup apps for Jimmy Lawson having 0 league cup goals?
CREATE TABLE table_name_74 (league_cup_apps INTEGER, league_cup_goals VARCHAR, name VARCHAR)
SELECT MAX(league_cup_apps) FROM table_name_74 WHERE league_cup_goals = 0 AND name = "jimmy lawson"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_74 (league_cup_apps INTEGER, league_cup_goals VARCHAR, name VARCHAR) Question: What's the most league cup apps for Jimmy Lawson having 0 league cup goals? [/INST] SELECT MAX(league_cup_apps) FROM table_name_74 WHERE league_cup_goals = 0 AND name = "jimmy lawson" </s>