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

Question: How many rounds were fought with opponent Kevin Roddy?
SQL: SELECT COUNT("round") FROM fighter_record_2 WHERE "opponent" = 'kevin roddy'