Name of gilmar, and a Caps smaller than 94 had how many highest goals?
CREATE TABLE "most_capped_players" (
  "name" text,
  "caps" real,
  "goals" real,
  "first_cap" text,
  "latest_cap" text
);
SELECT MAX("goals") FROM "most_capped_players" WHERE "name"='gilmar' AND "caps"<94;