What is the average Pick when the round was less than 6 for kenneth green?
CREATE TABLE table_name_7 (pick INTEGER, round VARCHAR, player VARCHAR)
SELECT AVG(pick) FROM table_name_7 WHERE round < 6 AND player = "kenneth green"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_7 (pick INTEGER, round VARCHAR, player VARCHAR) Question: What is the average Pick when the round was less than 6 for kenneth green? [/INST] SELECT AVG(pick) FROM table_name_7 WHERE round < 6 AND player = "kenneth green" </s>