CREATE TABLE table_12165999_1 (afl_team VARCHAR(255), player VARCHAR(255))
Bob Johnson plays for which AFL team?
    
SQL: SELECT afl_team FROM table_12165999_1 WHERE player = "Bob Johnson"