Table: issf_shooters_2
Columns: shooter
event
rank_points
score_points
total

Question: Which event had a total of 28?
SQL: SELECT "event" FROM issf_shooters_2 WHERE "total" = '28'

Question: Who was the shooter when the rank points was 8 and the event was WC Kerrville?
SQL: SELECT "shooter" FROM issf_shooters_2 WHERE "rank_points" = '8' AND "event" = 'wc kerrville'

Question: What was the total when the score points was 12 and the rank points was 15?
SQL: SELECT "total" FROM issf_shooters_2 WHERE "score_points" = '12' AND "rank_points" = '15'