user: ### NOW ANSWER:
Question: Name of gilmar, and a Caps smaller than 94 had how many highest goals?
Columns: ['Name', 'Caps', 'Goals', 'First cap', 'Latest cap']
Types: ['text', 'real', 'real', 'text', 'text']
Sample row: ['Cafu', 142.0, 5.0, 'September 12, 1990', 'July 1, 2006']
SQL:

assistant: SELECT MAX("Goals") FROM "Table" WHERE "Name" = 'gilmar' AND "Caps" < 94.0;