What opponent has final as the round?
CREATE TABLE "2007_08_cardiff_city_f_c_season" (
  "date" text,
  "round" text,
  "opponent" text,
  "venue" text,
  "result" text,
  "attendance" real
);
SELECT "opponent" FROM "2007_08_cardiff_city_f_c_season" WHERE "round"='final';