user: ### NOW ANSWER:
Question: Who are the opponents in district California 9?
Columns: ['District', 'Incumbent', 'Party', 'Elected', 'Status', 'Opponent']
Types: ['text', 'text', 'text', 'text', 'text', 'text']
Sample row: ['California 5', 'Nancy Pelosi', 'Democratic', '1987', 'Re-elected', 'Nancy Pelosi (D) 77.2% Alan Nichols (R) 22.8%']
SQL:

assistant: SELECT "Opponent" FROM "Table" WHERE "District" = 'California 9';