Table: mma_fight_results_24
Columns: res
record
opponent
method
event
round
time
location

Question: Which Method has a Round of 1, and a Record of 4–2?
SQL: SELECT "method" FROM mma_fight_results_24 WHERE "round" = 1 AND "record" = '4–2'

Question: Which Opponent has a Time of 4:51?
SQL: SELECT "opponent" FROM mma_fight_results_24 WHERE "time" = '4:51'

Question: Which Round has an Opponent of jorge magalhaes?
SQL: SELECT AVG("round") FROM mma_fight_results_24 WHERE "opponent" = 'jorge magalhaes'

Question: Which Round has a Location of bahia, brazil?
SQL: SELECT AVG("round") FROM mma_fight_results_24 WHERE "location" = 'bahia, brazil'

Question: Which Opponent has an Event of jungle fight 5?
SQL: SELECT "opponent" FROM mma_fight_results_24 WHERE "event" = 'jungle fight 5'