Table: soccer_players_2
Columns: rank
player
nation
caps
goals
years

Question: What is the sum of caps for players with less than 9 goals ranked below 8?
SQL: SELECT SUM("caps") FROM soccer_players_2 WHERE "goals" < 9 AND "rank" > 8