Who won the rookie award the week the transition award was given to Brodie Merrill and the offensive award was given to Pat Maddalena?
CREATE TABLE "weekly_awards" (
  "month" text,
  "week" real,
  "overall" text,
  "offensive" text,
  "defensive" text,
  "transition" text,
  "rookie" text
);
SELECT "rookie" FROM "weekly_awards" WHERE "transition"='Brodie Merrill' AND "offensive"='Pat Maddalena';