CREATE TABLE table_name_26 (president VARCHAR, treasurer VARCHAR, season VARCHAR)

Name the President who has a Treasurer of james davidson, and a Season of 2006 2007?
SELECT president FROM table_name_26 WHERE treasurer = "james davidson" AND season = "2006–2007"
SELECT "president" FROM "table_name_26" WHERE "2006–2007" = "season" AND "james davidson" = "treasurer"