Table: jerry_causon
Columns: name
career
goals
appearances
goals_game_ratio

Question: What was Lee Smith's highest number of goals when he made fewer than 364 appearances?
SQL: SELECT MAX("goals") FROM jerry_causon WHERE "name" = 'lee smith' AND "appearances" < 364

Question: What is the sum of Rob Coldray's goals when he made fewer than 348 appearances with goals/game ratio less than 0.313?
SQL: SELECT SUM("goals") FROM jerry_causon WHERE "goals_game_ratio" < 0.313 AND "name" = 'rob coldray' AND "appearances" < 348

Question: Which goals/game ratio has fewer than 201 goals and fewer than 170 appearances?
SQL: SELECT "goals_game_ratio" FROM jerry_causon WHERE "goals" < 201 AND "appearances" < 170