CREATE TABLE table_name_55 (pick VARCHAR2, name VARCHAR2, round VARCHAR2, overall VARCHAR2)

Which pick has a Round smaller than 8, and an Overall smaller than 16, and a Name of harry gilmer?
SELECT pick FROM table_name_55 WHERE round < 8 AND overall < 16 AND name = "harry gilmer"
SELECT "pick" FROM "table_name_55" WHERE "harry gilmer" = "name" AND "overall" < 16 AND "round" < 8