CREATE TABLE table_name_1 (acquired VARCHAR2, player VARCHAR2)

Who acquired tom norton?
SELECT acquired FROM table_name_1 WHERE player = "tom norton"
SELECT "acquired" FROM "table_name_1" WHERE "player" = "tom norton"