What is the total number of Rank with 100 goals, and less than 300 matches?
CREATE TABLE table_name_3 (rank VARCHAR, goals VARCHAR, matches VARCHAR)
SELECT COUNT(rank) FROM table_name_3 WHERE goals = 100 AND matches < 300
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_3 (rank VARCHAR, goals VARCHAR, matches VARCHAR) Question: What is the total number of Rank with 100 goals, and less than 300 matches? [/INST] SELECT COUNT(rank) FROM table_name_3 WHERE goals = 100 AND matches < 300 </s>