Name of gilmar, and a Caps smaller than 94 had how many highest goals?
CREATE TABLE table_name_18 (goals INTEGER, name VARCHAR, caps VARCHAR)
SELECT MAX(goals) FROM table_name_18 WHERE name = "gilmar" AND caps < 94
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_18 (goals INTEGER, name VARCHAR, caps VARCHAR) Question: Name of gilmar, and a Caps smaller than 94 had how many highest goals? [/INST] SELECT MAX(goals) FROM table_name_18 WHERE name = "gilmar" AND caps < 94 </s>