CREATE TABLE table_name_1 (team VARCHAR2, player VARCHAR2)

What team does Bill Walker play for?
SELECT team FROM table_name_1 WHERE player = "bill walker"
SELECT "team" FROM "table_name_1" WHERE "bill walker" = "player"