What is the total number of Attempts when Rank was larger than 4, and Net Yds was smaller than 1674?
CREATE TABLE table_name_95 (attempts VARCHAR, rank VARCHAR, net_yds VARCHAR)
SELECT COUNT(attempts) FROM table_name_95 WHERE rank > 4 AND net_yds < 1674
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_95 (attempts VARCHAR, rank VARCHAR, net_yds VARCHAR) Question: What is the total number of Attempts when Rank was larger than 4, and Net Yds was smaller than 1674? [/INST] SELECT COUNT(attempts) FROM table_name_95 WHERE rank > 4 AND net_yds < 1674 </s>