Table: mma_fight_results_31
Columns: res
record
opponent
method
event
round
location

Question: Did he win or lose rof 32: respect?
SQL: SELECT "res" FROM mma_fight_results_31 WHERE "event" = 'rof 32: respect'

Question: What round did he win rof 29: aftershock in?
SQL: SELECT "round" FROM mma_fight_results_31 WHERE "res" = 'win' AND "event" = 'rof 29: aftershock'

Question: How many rounds did the match last when his record was 6-6?
SQL: SELECT "round" FROM mma_fight_results_31 WHERE "record" = '6-6'

Question: How did the match end when his record was 15-11?
SQL: SELECT "method" FROM mma_fight_results_31 WHERE "record" = '15-11'