Table 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?
SQL: SELECT president FROM table_name_26 WHERE treasurer = "james davidson" AND season = "2006–2007"