CREATE TABLE table_name_94 (date VARCHAR, surface VARCHAR)

Tell me the total number of date for carpet
SELECT COUNT(date) FROM table_name_94 WHERE surface = "carpet"
SELECT COUNT("date") FROM "table_name_94" WHERE "carpet" = "surface"