CREATE TABLE table_204_868 (id NUMBER, "outcome" CLOB, "no." NUMBER, "date" CLOB, "tournament" CLOB, "surface" CLOB, "opponent" CLOB, "score" CLOB)

on how many dates was the outcome the same as on 1 august 2011
SELECT COUNT("date") FROM table_204_868 WHERE "date" <> '1 august 2011' AND "outcome" = (SELECT "outcome" FROM table_204_868 WHERE "date" = '1 august 2011')
SELECT COUNT("date") FROM "table_204_868" WHERE "date" <> '1 august 2011' AND "outcome" = (SELECT "outcome" FROM "table_204_868" WHERE "date" = '1 august 2011')