How many total rounds have the results of win, and n/a as the method?
CREATE TABLE table_name_12 (round VARCHAR, res VARCHAR, method VARCHAR)
SELECT COUNT(round) FROM table_name_12 WHERE res = "win" AND method = "n/a"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_12 (round VARCHAR, res VARCHAR, method VARCHAR) Question: How many total rounds have the results of win, and n/a as the method? [/INST] SELECT COUNT(round) FROM table_name_12 WHERE res = "win" AND method = "n/a" </s>