What is the sum of Rob Coldray's goals when he made fewer than 348 appearances with goals/game ratio less than 0.313?
CREATE TABLE "most_goals" (
  "name" text,
  "career" text,
  "goals" real,
  "appearances" real,
  "goals_game_ratio" real
);
SELECT SUM("goals") FROM "most_goals" WHERE "goals_game_ratio"<0.313 AND "name"='rob coldray' AND "appearances"<348;