What is the sum of the rounds where the overall pick was more than 295 and the pick was smaller than 10 and the player was rich dobbert?
CREATE TABLE table_name_93 (round INTEGER, pick VARCHAR, overall VARCHAR, name VARCHAR)
SELECT SUM(round) FROM table_name_93 WHERE overall > 295 AND name = "rich dobbert" AND pick < 10
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_93 (round INTEGER, pick VARCHAR, overall VARCHAR, name VARCHAR) Question: What is the sum of the rounds where the overall pick was more than 295 and the pick was smaller than 10 and the player was rich dobbert? [/INST] SELECT SUM(round) FROM table_name_93 WHERE overall > 295 AND name = "rich dobbert" AND pick < 10 </s>