user: ### NOW ANSWER:
Question: How many goals did he score with under 26 appearances for werder bremen?
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 COUNT("Goals") FROM "Table" WHERE "Apps." < 26.0 AND "Club" = 'werder bremen';