Before round 7, what is the greatest Pick # for a player that plays defensive tackle?
CREATE TABLE table_name_5 (pick__number INTEGER, position VARCHAR, round VARCHAR)
SELECT MAX(pick__number) FROM table_name_5 WHERE position = "defensive tackle" AND round < 7
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_5 (pick__number INTEGER, position VARCHAR, round VARCHAR) Question: Before round 7, what is the greatest Pick # for a player that plays defensive tackle? [/INST] SELECT MAX(pick__number) FROM table_name_5 WHERE position = "defensive tackle" AND round < 7 </s>