CREATE TABLE table_32478 ("Res." CLOB, "Record" CLOB, "Opponent" CLOB, "Method" CLOB, "Event" CLOB, "Round" FLOAT, "Time" CLOB, "Location" CLOB)

How many rounds were fought with opponent Kevin Roddy?
SELECT COUNT("Round") FROM table_32478 WHERE "Opponent" = 'kevin roddy'
SELECT COUNT("Round") FROM "table_32478" WHERE "Opponent" = 'kevin roddy'