Who did Winfield Scott have an allegiance with?
CREATE TABLE "line_officers" (
  "name" text,
  "date_of_birth" text,
  "actual_rank" text,
  "appointment_date" text,
  "allegiance" text
);
SELECT "allegiance" FROM "line_officers" WHERE "name"='winfield scott';