CREATE TABLE table_33539 ("Name" CLOB, "Date of birth" CLOB, "Actual rank" CLOB, "Appointment date" CLOB, "Allegiance" CLOB)

Who did Winfield Scott have an allegiance with?
SELECT "Allegiance" FROM table_33539 WHERE "Name" = 'winfield scott'
SELECT "Allegiance" FROM "table_33539" WHERE "Name" = 'winfield scott'