Table: senators_39th_parliament
Columns: date
name
party
province
details

Question: Which province has Michael Kirby?
SQL: SELECT "province" FROM senators_39th_parliament WHERE "name" = 'michael kirby'

Question: Which party is Madeleine Plamondon a member of?
SQL: SELECT "party" FROM senators_39th_parliament WHERE "name" = 'madeleine plamondon'

Question: What are the details for Marisa Ferretti Barth?
SQL: SELECT "details" FROM senators_39th_parliament WHERE "name" = 'marisa ferretti barth'

Question: Which party had a member on August 26, 2008?
SQL: SELECT "party" FROM senators_39th_parliament WHERE "date" = 'august 26, 2008'

Question: What are the details for John Buchanan?
SQL: SELECT "details" FROM senators_39th_parliament WHERE "name" = 'john buchanan'

Question: Which province had a liberal party member on December 31, 2006?
SQL: SELECT "province" FROM senators_39th_parliament WHERE "party" = 'liberal' AND "date" = 'december 31, 2006'