user: Question: What is the sum of caps for players with less than 9 goals ranked below 8?
Columns: ['Rank', 'Player', 'Nation', 'Caps', 'Goals', 'Years']
Types: ['real', 'text', 'text', 'real', 'real', 'text']
Sample row: [1.0, 'Nick Rimando', 'USA', 201.0, 0.0, '2007–present']
SQL:

assistant: SELECT SUM("Caps") FROM "Table" WHERE "Goals" < 9.0 AND "Rank" > 8.0;