Table: fighter_results_9
Columns: res
record
opponent
method
event
round

Question: Who was the opponent in the 1 round fight in the Ultimate Fighter 2 Finale?
SQL: SELECT "opponent" FROM fighter_results_9 WHERE "round" = '1' AND "event" = 'the ultimate fighter 2 finale'

Question: Who is the opponent in the fight of 1 round when the record is 18-7?
SQL: SELECT "opponent" FROM fighter_results_9 WHERE "round" = '1' AND "record" = '18-7'

Question: What is the record at the UW: Ultimate Fight Minnesota?
SQL: SELECT "record" FROM fighter_results_9 WHERE "event" = 'uw: ultimate fight minnesota'

Question: What is the record in the 2 round fight that ended by submission (injury)?
SQL: SELECT "record" FROM fighter_results_9 WHERE "round" = '2' AND "method" = 'submission (injury)'

Question: Who is the opponent at the IFA: Clash of the Champions?
SQL: SELECT "opponent" FROM fighter_results_9 WHERE "event" = 'ifa: clash of the champions'

Question: What is the record that resulted in a loss at the RSF: Shooto Challenge 2?
SQL: SELECT "record" FROM fighter_results_9 WHERE "res" = 'loss' AND "event" = 'rsf: shooto challenge 2'