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"