CREATE TABLE table_name_67 (league NUMBER, total NUMBER)

What is the lowest number of goals scored by a player in the normal league games where more than 8 total goals were scored?
SELECT MIN(league) FROM table_name_67 WHERE total > 8
SELECT MIN("league") FROM "table_name_67" WHERE "total" > 8