Bob Johnson plays for which AFL team?
CREATE TABLE table_12165999_1 (afl_team VARCHAR, player VARCHAR)
SELECT afl_team FROM table_12165999_1 WHERE player = "Bob Johnson"
### Context: CREATE TABLE table_12165999_1 (afl_team VARCHAR, player VARCHAR) ### Question: Bob Johnson plays for which AFL team? ### Answer: SELECT afl_team FROM table_12165999_1 WHERE player = "Bob Johnson"