Who was the shooter when the rank points was 8 and the event was WC Kerrville?
CREATE TABLE "qualification" (
  "shooter" text,
  "event" text,
  "rank_points" text,
  "score_points" text,
  "total" text
);
SELECT "shooter" FROM "qualification" WHERE "rank_points"='8' AND "event"='wc kerrville';