Who captains Portsmouth?
CREATE TABLE "personnel_and_kits" (
  "team" text,
  "manager" text,
  "captain" text,
  "kit_maker" text,
  "shirt_sponsor" text
);
SELECT "captain" FROM "personnel_and_kits" WHERE "team"='portsmouth';