What is the lowest total of player tommy ring, who has a rank greater than 1?
CREATE TABLE "single_game" (
  "rank" real,
  "player" text,
  "county" text,
  "tally" text,
  "total" real,
  "opposition" text
);
SELECT MIN("total") FROM "single_game" WHERE "player"='tommy ring' AND "rank">1;