CREATE TABLE table_name_1 (opponent VARCHAR2, man_of_the_match VARCHAR2)

Who was the Opponent when Terry Miles was the Man of the Match?
SELECT opponent FROM table_name_1 WHERE man_of_the_match = "terry miles"
SELECT "opponent" FROM "table_name_1" WHERE "man_of_the_match" = "terry miles"