user: ### NOW ANSWER:
Question: How many goals occurred for Stein Huysegems when the caps value is more than 8?
Columns: ['Player', 'Country', 'Caps', 'Goals', 'Years Active']
Types: ['text', 'text', 'real', 'text', 'text']
Sample row: ['Glen Moss', 'New Zealand', 21.0, '(0)', '2006–']
SQL:

assistant: SELECT "Goals" FROM "Table" WHERE "Caps" > 8.0 AND "Player" = 'Stein Huysegems';