user: ### NOW ANSWER:
Question: who is the actor that played Rachel McKenna?
Columns: ['Actor', 'Character', 'Soap Opera', 'Years', 'Duration']
Types: ['text', 'text', 'text', 'text', 'text']
Sample row: ['Michael Galvin', 'Chris Warner', 'Shortland Street', '1992–1996, 2000—', '18 years']
SQL:

assistant: SELECT "Actor" FROM "Table" WHERE "Character" = 'Rachel McKenna';