What Year was james mcclure Deputy, and the Name is robert mcphearson?
CREATE TABLE table_name_44 (year VARCHAR, deputy VARCHAR, name VARCHAR)
SELECT year FROM table_name_44 WHERE deputy = "james mcclure" AND name = "robert mcphearson"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_44 (year VARCHAR, deputy VARCHAR, name VARCHAR) Question: What Year was james mcclure Deputy, and the Name is robert mcphearson? [/INST] SELECT year FROM table_name_44 WHERE deputy = "james mcclure" AND name = "robert mcphearson" </s>