What is the total number of Pick #, when College is Oklahoma, and when Round is less than 4?
CREATE TABLE table_name_55 (pick__number VARCHAR, college VARCHAR, round VARCHAR)
SELECT COUNT(pick__number) FROM table_name_55 WHERE college = "oklahoma" AND round < 4
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_55 (pick__number VARCHAR, college VARCHAR, round VARCHAR) Question: What is the total number of Pick #, when College is Oklahoma, and when Round is less than 4? [/INST] SELECT COUNT(pick__number) FROM table_name_55 WHERE college = "oklahoma" AND round < 4 </s>