Table: fighter_results_4
Columns: res
record
opponent
method
round
time
location

Question: Who was the opponent when Raphael was 4-0?
SQL: SELECT "opponent" FROM fighter_results_4 WHERE "record" = '4-0'

Question: What was the average round when he had a 3-0 record?
SQL: SELECT AVG("round") FROM fighter_results_4 WHERE "record" = '3-0'

Question: What was the location when he had a 2-0 record?
SQL: SELECT "location" FROM fighter_results_4 WHERE "record" = '2-0'

Question: What was the result when he went 1 round against jeremy beck?
SQL: SELECT "res" FROM fighter_results_4 WHERE "round" = 1 AND "opponent" = 'jeremy beck'