What is Opponent, when Result is Win, and when Date is Aug 7?
CREATE TABLE "season_schedule" (
  "week" real,
  "date" text,
  "opponent" text,
  "score" text,
  "result" text,
  "attendance" text,
  "record" text
);
SELECT "opponent" FROM "season_schedule" WHERE "result"='win' AND "date"='aug 7';