What is the sum of all the rounds when a Florida State player was drafted?
CREATE TABLE table_name_8 (round VARCHAR, college VARCHAR)
SELECT COUNT(round) FROM table_name_8 WHERE college = "florida state"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_8 (round VARCHAR, college VARCHAR) Question: What is the sum of all the rounds when a Florida State player was drafted? [/INST] SELECT COUNT(round) FROM table_name_8 WHERE college = "florida state" </s>