user: ### NOW ANSWER:
Question: How many goals did he have in the bundesliga with under 7 appearances?
Columns: ['Season', 'Club', 'Country', 'Competition', 'Apps.', 'Goals']
Types: ['text', 'text', 'text', 'text', 'real', 'real']
Sample row: ['2006–07', 'IF Elfsborg', 'Sweden', 'Allsvenskan', 19.0, 0.0]
SQL:

assistant: SELECT AVG("Goals") FROM "Table" WHERE "Competition" = 'bundesliga' AND "Apps." < 7.0;