CREATE TABLE table_203_778 (id NUMBER, "representative" CLOB, "title" CLOB, "presentation\ of credentials" CLOB, "termination\ of mission" CLOB, "appointed by" CLOB)

which reps were only appointed by franklin pierce ?
SELECT "representative" FROM table_203_778 WHERE "appointed by" = 'franklin pierce'
SELECT "representative" FROM "table_203_778" WHERE "appointed by" = 'franklin pierce'