CREATE TABLE table_75786 ("Name" TEXT, "Appointed" TEXT, "Prior position" TEXT, "Province" TEXT, "Nominated by" TEXT)

Who was appointed on October 21, 2011 from Quebec?
SELECT "Name" FROM table_75786 WHERE "Province" = 'quebec' AND "Appointed" = 'october 21, 2011'
SELECT "Name" FROM "table_75786" WHERE "Appointed" = 'october 21, 2011' AND "Province" = 'quebec'