Table: georges_emile_lapalme
Columns: name
district_region
took_office
left_office
party

Question: François Gendron was in which party?
SQL: SELECT "party" FROM georges_emile_lapalme WHERE "name" = 'françois gendron'

Question: The deputy that left office in 2003 took office in which year?
SQL: SELECT "took_office" FROM georges_emile_lapalme WHERE "left_office" = '2003'

Question: Which deputy took office in 1976?
SQL: SELECT "name" FROM georges_emile_lapalme WHERE "took_office" = '1976'