Name the  President who has a Treasurer of james davidson, and a Season of 2006–2007?
CREATE TABLE table_name_26 (president VARCHAR, treasurer VARCHAR, season VARCHAR)
SELECT president FROM table_name_26 WHERE treasurer = "james davidson" AND season = "2006–2007"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_26 (president VARCHAR, treasurer VARCHAR, season VARCHAR) Question: Name the  President who has a Treasurer of james davidson, and a Season of 2006–2007? [/INST] SELECT president FROM table_name_26 WHERE treasurer = "james davidson" AND season = "2006–2007" </s>