CREATE TABLE table_12002 ("Name" CLOB, "District  ( Region ) " CLOB, "Took Office" CLOB, "Left Office" CLOB, "Party" CLOB)

Fran ois Gendron was in which party?
SELECT "Party" FROM table_12002 WHERE "Name" = 'françois gendron'
SELECT "Party" FROM "table_12002" WHERE "Name" = 'françois gendron'