Table schema:
CREATE TABLE table_12165999_1 (afl_team VARCHAR, player VARCHAR)

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