what is the year when the location is san diego, california and defeated is houston baptist (texas)?
CREATE TABLE table_name_96 (year VARCHAR, location VARCHAR, defeated VARCHAR)
SELECT COUNT(year) FROM table_name_96 WHERE location = "san diego, california" AND defeated = "houston baptist (texas)"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_96 (year VARCHAR, location VARCHAR, defeated VARCHAR) Question: what is the year when the location is san diego, california and defeated is houston baptist (texas)? [/INST] SELECT COUNT(year) FROM table_name_96 WHERE location = "san diego, california" AND defeated = "houston baptist (texas)" </s>