Which pick has a Round smaller than 8, and an Overall smaller than 16, and a Name of harry gilmer?
CREATE TABLE table_name_55 (pick VARCHAR, name VARCHAR, round VARCHAR, overall VARCHAR)
SELECT pick FROM table_name_55 WHERE round < 8 AND overall < 16 AND name = "harry gilmer"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_55 (pick VARCHAR, name VARCHAR, round VARCHAR, overall VARCHAR) Question: Which pick has a Round smaller than 8, and an Overall smaller than 16, and a Name of harry gilmer? [/INST] SELECT pick FROM table_name_55 WHERE round < 8 AND overall < 16 AND name = "harry gilmer" </s>