Tell me the total number of date for carpet
CREATE TABLE table_name_94 (date VARCHAR, surface VARCHAR)
SELECT COUNT(date) FROM table_name_94 WHERE surface = "carpet"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_94 (date VARCHAR, surface VARCHAR) Question: Tell me the total number of date for carpet [/INST] SELECT COUNT(date) FROM table_name_94 WHERE surface = "carpet" </s>