Table: mma_fights_8
Columns: res
record
opponent
method
event
round

Question: Which opponent has a record of 5-0-1?
SQL: SELECT "opponent" FROM mma_fights_8 WHERE "record" = '5-0-1'

Question: What method does the opponent of Dan New use?
SQL: SELECT "method" FROM mma_fights_8 WHERE "opponent" = 'dan new'

Question: Which method has a record of 3-0?
SQL: SELECT "method" FROM mma_fights_8 WHERE "record" = '3-0'

Question: Which event is a win by an opponent of Nicolas Smith, with the round marked n/a?
SQL: SELECT "event" FROM mma_fights_8 WHERE "res" = 'win' AND "round" = 'n/a' AND "opponent" = 'nicolas smith'

Question: Which event lasted 1 round and included an opponent of Dan Spychalski?
SQL: SELECT "event" FROM mma_fights_8 WHERE "round" = '1' AND "opponent" = 'dan spychalski'

Question: What is Jimmy Smith's opponent's record?
SQL: SELECT "record" FROM mma_fights_8 WHERE "opponent" = 'jimmy smith'