What was the final score on 1 August 2008?
CREATE TABLE "pre_season_tournaments_and_friendlies" (
  "date" text,
  "tournament" text,
  "location" text,
  "opponent_team" text,
  "score" text
);
SELECT "score" FROM "pre_season_tournaments_and_friendlies" WHERE "date"='1 august 2008';