What was Lee Smith's highest number of goals when he made fewer than 364 appearances?
CREATE TABLE "most_goals" (
  "name" text,
  "career" text,
  "goals" real,
  "appearances" real,
  "goals_game_ratio" real
);
SELECT MAX("goals") FROM "most_goals" WHERE "name"='lee smith' AND "appearances"<364;