What is the highest round of Tommy Allman, who had a pick less than 40?
CREATE TABLE table_name_27 (round INTEGER, player VARCHAR, pick VARCHAR)
SELECT MAX(round) FROM table_name_27 WHERE player = "tommy allman" AND pick < 40
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_27 (round INTEGER, player VARCHAR, pick VARCHAR) Question: What is the highest round of Tommy Allman, who had a pick less than 40? [/INST] SELECT MAX(round) FROM table_name_27 WHERE player = "tommy allman" AND pick < 40 </s>