user: ### NOW ANSWER:
Question: What is the average number of goals of the player with 234 apps and a rank above 8?
Columns: ['Rank', 'Player', 'Goals', 'Apps', 'Avg/Game']
Types: ['real', 'text', 'real', 'real', 'real']
Sample row: [1.0, 'Oleg Veretennikov', 143.0, 274.0, 0.52]
SQL:

assistant: SELECT AVG("Goals") FROM "Table" WHERE "Apps" = 234.0 AND "Rank" < 8.0;