How many July 1, 2013 projections have a Rank of 27?
CREATE TABLE table_name_58 (_2013_projection VARCHAR, july_1 VARCHAR, rank VARCHAR)
SELECT COUNT(july_1), _2013_projection FROM table_name_58 WHERE rank = "27"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_58 (_2013_projection VARCHAR, july_1 VARCHAR, rank VARCHAR) Question: How many July 1, 2013 projections have a Rank of 27? [/INST] SELECT COUNT(july_1), _2013_projection FROM table_name_58 WHERE rank = "27" </s>