user: Question: Who was the man of the match when the Rockets won by 9 wickets? 
Columns: ['Scorecard', 'Date', 'Venue', 'Team 1', 'Team 2', 'Result', 'Man of the Match']
Types: ['real', 'text', 'text', 'text', 'text', 'text', 'text']
Sample row: [1.0, 'October 10', 'Hyderabad', 'Lahore Badshahs', 'Hyderabad Heroes', 'Heroes won by 18 runs ( VJD method )', 'Ambati Rayudu (Heroes)']
SQL:

assistant: SELECT "Man of the Match" FROM "Table" WHERE "Result" = 'Rockets won by 9 wickets';