Table: election_results_1946_4
Columns: office
republican_ticket
democratic_ticket
american_labor_ticket
liberal_ticket
communist_ticket

Question: What is the American Labor ticket when Henry Epstein is the liberal ticket?
SQL: SELECT "american_labor_ticket" FROM election_results_1946_4 WHERE "liberal_ticket" = 'henry epstein'

Question: What is the name on the Communist ticket with an Office of judge of the court of appeals?
SQL: SELECT "communist_ticket" FROM election_results_1946_4 WHERE "office" = 'judge of the court of appeals'

Question: What is the Office when spencer c. young is on the liberal ticket??
SQL: SELECT "office" FROM election_results_1946_4 WHERE "liberal_ticket" = 'spencer c. young'

Question: What is the name on the Democratic ticket when the Liberal ticket is erastus corning 2nd?
SQL: SELECT "democratic_ticket" FROM election_results_1946_4 WHERE "liberal_ticket" = 'erastus corning 2nd'

Question: What name is on the Republican ticket when the  American Labor ticket was spencer c. young?
SQL: SELECT "republican_ticket" FROM election_results_1946_4 WHERE "american_labor_ticket" = 'spencer c. young'