What is the lowest League Cup Goals, when Scorer is Denis Law?
CREATE TABLE table_name_59 (league_cup_goals INTEGER, scorer VARCHAR)
SELECT MIN(league_cup_goals) FROM table_name_59 WHERE scorer = "denis law"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_59 (league_cup_goals INTEGER, scorer VARCHAR) Question: What is the lowest League Cup Goals, when Scorer is Denis Law? [/INST] SELECT MIN(league_cup_goals) FROM table_name_59 WHERE scorer = "denis law" </s>