Name the total number for report july 23
CREATE TABLE table_2267857_1 (report VARCHAR, date VARCHAR)
SELECT COUNT(report) FROM table_2267857_1 WHERE date = "July 23"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_2267857_1 (report VARCHAR, date VARCHAR) Question: Name the total number for report july 23 [/INST] SELECT COUNT(report) FROM table_2267857_1 WHERE date = "July 23" </s>