CREATE TABLE table_name_59 (record VARCHAR2, opponent VARCHAR2, method VARCHAR2)

What record has magomedkhan gamzatkhanov as the opponent, and submission as the method?
SELECT record FROM table_name_59 WHERE opponent = "magomedkhan gamzatkhanov" AND method = "submission"
SELECT "record" FROM "table_name_59" WHERE "magomedkhan gamzatkhanov" = "opponent" AND "method" = "submission"