CREATE TABLE table_name_28 (allegiance VARCHAR2, name VARCHAR2)

Who did Winfield Scott have an allegiance with?
SELECT allegiance FROM table_name_28 WHERE name = "winfield scott"
SELECT "allegiance" FROM "table_name_28" WHERE "name" = "winfield scott"