What year was incumbent joe b. bates first elected?
CREATE TABLE table_1342233_17 (first_elected VARCHAR, incumbent VARCHAR)
SELECT first_elected FROM table_1342233_17 WHERE incumbent = "Joe B. Bates"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_1342233_17 (first_elected VARCHAR, incumbent VARCHAR) Question: What year was incumbent joe b. bates first elected? [/INST] SELECT first_elected FROM table_1342233_17 WHERE incumbent = "Joe B. Bates" </s>