CREATE TABLE table_42297 ("Office" CLOB, "Democratic ticket" CLOB, "Republican ticket" CLOB, "American Labor ticket" CLOB, "Socialist ticket" CLOB)

Who's the Republican ticket with a Democratic ticket of m. william bray?
SELECT "Republican ticket" FROM table_42297 WHERE "Democratic ticket" = 'm. william bray'
SELECT "Republican ticket" FROM "table_42297" WHERE "Democratic ticket" = 'm. william bray'