What team does Anthony Redmond ride for?
CREATE TABLE "race_6b_ultra_lightweight_manx_grand_pri" (
  "rank" real,
  "rider" text,
  "team" text,
  "speed" text,
  "time" text
);
SELECT "team" FROM "race_6b_ultra_lightweight_manx_grand_pri" WHERE "rider"='anthony redmond';