CREATE TABLE table_12165999_1 (afl_team VARCHAR, player VARCHAR)

Bob Johnson plays for which AFL team?
SELECT afl_team FROM table_12165999_1 WHERE player = "Bob Johnson"
SELECT "afl_team" FROM "table_12165999_1" WHERE "Bob Johnson" = "player"