user: Question: Name the  President who has a Treasurer of James Davidson, and a Season of 2006–2007?
Columns: ['Season', 'President', 'General Sec', 'Treasurer', 'Fixtures Sec', 'Social Sec Bradford', 'Social Sec Leeds', 'Media Officer']
Types: ['text', 'text', 'text', 'text', 'text', 'text', 'text', 'text']
Sample row: ['2004–2005', 'Ben Nunney', 'N/A', 'Ben Neal', 'N/A', 'Hassan Majeed/ Louisa Bellis', 'N/A', 'Mike Currie']
SQL:

assistant: SELECT "President" FROM "Table" WHERE "Treasurer" = 'James Davidson' AND "Season" = '2006–2007';