WHAT IS THE OVERALL AVERAGE WITH A 22 PICK, FROM RICE COLLEGE, AND ROUND BIGGER THAN 10?
CREATE TABLE table_name_23 (overall INTEGER, round VARCHAR, pick VARCHAR, college VARCHAR)
SELECT AVG(overall) FROM table_name_23 WHERE pick = 22 AND college = "rice" AND round > 10
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_23 (overall INTEGER, round VARCHAR, pick VARCHAR, college VARCHAR) Question: WHAT IS THE OVERALL AVERAGE WITH A 22 PICK, FROM RICE COLLEGE, AND ROUND BIGGER THAN 10? [/INST] SELECT AVG(overall) FROM table_name_23 WHERE pick = 22 AND college = "rice" AND round > 10 </s>