CREATE TABLE table_name_97 (opponent VARCHAR2, method VARCHAR2)

Which Opponent has a Method of submission?
SELECT opponent FROM table_name_97 WHERE method = "submission"
SELECT "opponent" FROM "table_name_97" WHERE "method" = "submission"