user: Question: Who is the head coach when Miami University is the championship game opponent?
Columns: ['Tournament', 'Conference', 'Championship Game Opponent', 'Score', 'Location', 'Head Coach']
Types: ['real', 'text', 'text', 'text', 'text', 'text']
Sample row: [1994.0, 'CCHA', 'Lake Superior State', '3-0', 'Joe Louis Arena Detroit, MI', 'Red Berenson']
SQL:

assistant: SELECT "Head Coach" FROM "Table" WHERE "Championship Game Opponent" = 'Miami University';