Table: fighter_results_11
Columns: res
record
opponent
method
event
round

Question: In what event is the opponent Joe Nameth?
SQL: SELECT "event" FROM fighter_results_11 WHERE "opponent" = 'joe nameth'

Question: What is the record when the loss was to Alex Hunter in round 1?
SQL: SELECT "record" FROM fighter_results_11 WHERE "round" = '1' AND "res" = 'loss' AND "opponent" = 'alex hunter'

Question: What is the method when the opponent is Andre Roberts?
SQL: SELECT "method" FROM fighter_results_11 WHERE "opponent" = 'andre roberts'

Question: What is the round when the opponent is Andre Roberts?
SQL: SELECT "round" FROM fighter_results_11 WHERE "opponent" = 'andre roberts'

Question: What is the round when the loss came with a record of 2-4?
SQL: SELECT "round" FROM fighter_results_11 WHERE "res" = 'loss' AND "record" = '2-4'

Question: How many rounds was the fight with a decision by submission (punches)?
SQL: SELECT "round" FROM fighter_results_11 WHERE "method" = 'submission (punches)'