What is Weekly Winner, when Air Date is "July 4, 2008"?
CREATE TABLE "ratings_and_results" (
  "air_date" text,
  "rating" text,
  "18_49" text,
  "viewers" text,
  "weekly_winner" text
);
SELECT "weekly_winner" FROM "ratings_and_results" WHERE "air_date"='july 4, 2008';