user: ### NOW ANSWER:
Question: Which coach has a conference record of 42-78?
Columns: ['Coach', 'Years', 'Record', 'Conference Record', 'Overall Win Percentage']
Types: ['text', 'text', 'text', 'text', 'text']
Sample row: ['James C. Elsom', '1898–1904', '25-14', '–', '64%']
SQL:

assistant: SELECT "Coach" FROM "Table" WHERE "Conference Record" = '42-78';