What is the lowest number of goals scored by a player in the normal league games where more than 8 total goals were scored?
CREATE TABLE table_name_67 (league INTEGER, total INTEGER)
SELECT MIN(league) FROM table_name_67 WHERE total > 8
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_67 (league INTEGER, total INTEGER) Question: What is the lowest number of goals scored by a player in the normal league games where more than 8 total goals were scored? [/INST] SELECT MIN(league) FROM table_name_67 WHERE total > 8 </s>