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"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_12165999_1 (afl_team VARCHAR, player VARCHAR) Question: Bob Johnson plays for which AFL team? [/INST] SELECT afl_team FROM table_12165999_1 WHERE player = "Bob Johnson" </s>